We can use Normalizer transformation for this. If we do not want to use Normalizer, then there is one alternate way for this.
We have a source table containing 3 columns: Col1, Col2 and Col3. There is only 1 row in the table as follows:
There is target table contains only 1 column Col. Design a mapping so that the target table contains 3 rows as follows:
- 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.