Home » Developer & Programmer » Data Integration » Help required (OWB 10.2)
Help required [message #356092] Wed, 29 October 2008 08:44
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
Previous Topic: Loading data into 2 different schemas
Goto Forum:

Current Time: Mon Mar 20 10:31:51 CDT 2023