I have a requirement. Based on the input column value, I need to insert one record as a two records with different values in other respective columns by getting from lookup tables. My job flow is like below
Code: Select all
Oracle1--->Transformer1---------->Lookup1-----------------> Transformer2-----
| ^ ^ ^ |
| | | | |
| Oracle2----->Filter1 Filter2<-----Oracle3 Funnel---->dataset
| | | | | |
| v v v v |
|--------------->Lookup2-----------------> Transformer3------