Pages

Sunday, March 17, 2013

Convert single row from source to three rows in target


We have a source table containing 3 columns : Col1, Col2 and Col3. There is only 1 row in the table as follows:
Col1Col2Col3
abc
There is target table containg only 1 column Col. Design a mapping so that the target table contains 3 rows as follows:
Col
a
b
c
Without using normaliser transformation.
Solution:
row to column transformation
 Create 3 expression transformations exp_1,exp_2 and exp_3 with 1 port each. Connect col1 from Source Qualifier to port in exp_1.Connect col2 from Source Qualifier to port in exp_2.Connect col3 from source qualifier to port in exp_3. Make 3 instances of the target. Connect port from exp_1 to target_1. Connect port from exp_2 to target_2 and connect port from exp_3 to target_3.

No comments:

Post a Comment