knowledgebase:performing_row_denormalisation_using_case_function

Performing Row Denormalisation using Case function

This example demonstrates how to de-normalize data by looking up key-value pairs.

ClientID Key Value
ClientID1NameBill
ClientID1Phone1234567
ClientID2NameMark
ClientID2Phone123456
ClientID Name Phone
ClientID1Bill1234567
ClientID2Mark123456

The beauty of the “Case” function is its incredible flexibility, The data can be redirected in many ways using multiple criteria, that reduces clutter and makes it easy to understand complex ETL processes

For more technologies supported by our ETL Software see Advanced ETL Processor Versions and Visual Importer ETL Versions

Confused? Ask question on our ETL forum

  • knowledgebase/performing_row_denormalisation_using_case_function.txt
  • Last modified: 13/04/2019 16:52
  • by admin