| Help required [message #356092] |
Wed, 29 October 2008 08:44 |
nithinlenin
Messages: 9
Registered: October 2008
Location: Bangalore
|
Junior Member |
|
|
Please help me with the mapping
Following is the scenario
table A - Source table with columns country_code, store number, valid to , valid_from date ..... etc
table B - Dimension table with country_code, store_number etc
table C - clean table
table E - Error table
I have to make a mapping in such a way as to check for the country code , store number for table A , whether it exists in the Dimension table B
If yes -- those records go into table C
If no ---- those records go into table E
Now , If i use a joiner i am not able to capture the error data
Is there any other way i can acheive the same
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
