Scenario: We have a source having 10 records with 3 columns and target with 1 column. we have to design a mapping to load each column of each record into target.
Example:
Source:
Example:
Source:
| Name | Father_Name | Mother_Name |
| RAGHU | RAM | RATHNA |
Target:
|
Solutions: Create an Expression transformation exp_<Name> and then pull the required ports from source qualifier to expression. Make 3 Instances of the target and connect port1 from expression to target_1, port2 from expression to target_2 and then port3 from expression to target_3.
Comments
Post a Comment