Creating the Reject files for Source and Refrence tables
Posted: Thu Feb 04, 2010 4:21 am
Hi ,
I am having 2 Tables Product and Category. My requirement is I have to capture the records those are present in Product table and not found in Category table and Vice versa in a single job. The common key is product _id.
PRODUCT CATEGORY
*********** ***************
PROD ID CATG_ID CATG_ID CATG_NAME PROD ID
1 100 100 ABC 1
2 101 101 PQR 2
3 102 103 RTS 4
Now in Project reject file I have to get " 3 102 " and CATEGORY reject I have to get " 103 RTS 4" .
Can anyone please tell me how to resolve this?
Thanks and Regards
Siva
I am having 2 Tables Product and Category. My requirement is I have to capture the records those are present in Product table and not found in Category table and Vice versa in a single job. The common key is product _id.
PRODUCT CATEGORY
*********** ***************
PROD ID CATG_ID CATG_ID CATG_NAME PROD ID
1 100 100 ABC 1
2 101 101 PQR 2
3 102 103 RTS 4
Now in Project reject file I have to get " 3 102 " and CATEGORY reject I have to get " 103 RTS 4" .
Can anyone please tell me how to resolve this?
Thanks and Regards
Siva