Scenario:
I have a task for which I am not able to find a logic. It is exception handling.
I have a column 'region' in table 'user'. 1 user can belong to more than 1 region. Total I have 10 regions. Exception is 1 user has 'ALL' in the region column. I have to select all the distinct regions and apply it to 'ALL'. the output should have 10 records of the user corresponding to each region.
How can I equal 'ALL' to 10 regions and get 10 records into the target?
Scenario:
Please follow the below steps
1. Use two flow in your mapping in first flow pass all data with Region != 'ALL'
2. In second flow pass the data with Region=ALL to exp where create 10 output port with value of 10 region
3. then pass all columns to normalizer and in Normalizer create o/p port in which for Region port set occurrence to 10.
3. Pass data to target table.
I have a task for which I am not able to find a logic. It is exception handling.
I have a column 'region' in table 'user'. 1 user can belong to more than 1 region. Total I have 10 regions. Exception is 1 user has 'ALL' in the region column. I have to select all the distinct regions and apply it to 'ALL'. the output should have 10 records of the user corresponding to each region.
How can I equal 'ALL' to 10 regions and get 10 records into the target?
Scenario:
Please follow the below steps
1. Use two flow in your mapping in first flow pass all data with Region != 'ALL'
2. In second flow pass the data with Region=ALL to exp where create 10 output port with value of 10 region
3. then pass all columns to normalizer and in Normalizer create o/p port in which for Region port set occurrence to 10.
3. Pass data to target table.
Comments
Post a Comment