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
Rejected records from both Primary and Reference table
Moderators: chulett, rschirm, roy
Rejected records from both Primary and Reference table
harshakumar mc
Why is this issue marked as resolved in server forum and then asked again in the parallel forum?
viewtopic.php?t=115678
viewtopic.php?t=115678
Re: Rejected records from both Primary and Reference table
Lookup stage, not possible...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
Join stage in 'Full Outer Join' mode followed by a filter/transformer..
-
- Premium Member
- Posts: 783
- Joined: Mon Jan 16, 2006 10:17 pm
- Location: Sydney, Australia