Page 1 of 1
Rejected records from both Primary and Reference table
Posted: Fri Jan 11, 2008 3:03 am
by mc_harsha
All,
Input:
Table A - Primary link A.key1
Table B - Reference link B.key1
Output:
3 Output Files
- Get all the records which are in both the tables(A.key1=B.key1)
- Records which are there only in table A
- Records which are there only in table B
Is the above output possiable using single look up stage or merge?
Give me your thoughts what would be the design for this?
regards,
Harsha
Posted: Fri Jan 11, 2008 3:12 am
by Maveric
Why is this issue marked as resolved in server forum and then asked again in the parallel forum?
viewtopic.php?t=115678
Re: Rejected records from both Primary and Reference table
Posted: Fri Jan 11, 2008 3:16 am
by Havoc
mc_harsha wrote:All,
Input:
Table A - Primary link A.key1
Table B - Reference link B.key1
Output:
3 Output Files
- Get all the records which are in both the tables(A.key1=B.key1)
- Records which are there only in table A
- Records which are there only in table B
Is the above output possiable using single look up stage or merge?
Give me your thoughts what would be the design for this?
regards,
Harsha
Lookup stage, not possible...
Join stage in 'Full Outer Join' mode followed by a filter/transformer..
Posted: Fri Jan 11, 2008 3:50 am
by mc_harsha
Yup........
Can you explain more what you will do in Filter/transformer?
Thanks,
Harsha
Posted: Fri Jan 11, 2008 3:59 am
by Maveric
Check for nulls in Left.Key1 and Right.Key1. Refer to your previous post in server forum.
Posted: Sat Jan 12, 2008 6:47 am
by keshav0307
you can also do it by using a CDC of difference stage and the a filter or transformer stage.
in CDC, if it is marked new, it is only available in A.
if marked deleted then only avaiable in B
if marked copy or updated then available in both