Performing Row Denormalisation using Case function
This example demonstrates how to de-normalize data by looking up key-value pairs.
Source Data:
| ClientID | Key | Value |
|---|---|---|
| ClientID1 | Name | Bill |
| ClientID1 | Phone | 1234567 |
| ClientID2 | Name | Mark |
| ClientID2 | Phone | 123456 |
Desired Result
| ClientID | Name | Phone |
|---|---|---|
| ClientID1 | Bill | 1234567 |
| ClientID2 | Mark | 123456 |
Transformation
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
Confused? Ask question on our ETL Forum