Rejected records from both Primary and Reference table

mc_harsha · Post by **mc_harsha** » Thu Jan 10, 2008 3:40 am

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

Maveric · Post by **Maveric** » Thu Jan 10, 2008 3:52 am

Full outer join. This will give you Left.Key1 and right.Key1 fields in the output. Now check to see if there are nulls in these two field. If Left.Key1 is null then this record is present only in Right link. If Right.Key1 is null then this record is present only in Left link. If both are not null then there is matching record in both the links. Andi cannot see a scenario where both can be nulls.