Job based scenario

TABLE T1 with c1 and Table T2 with c1
1 3
2 4
2 5
3
4
5
5
6
7
These 2 are my source tables and i should get o/p as 1,2,2,6,7
Desing a Parrllel job in datastage

Showing Answers 1 - 6 of 6 Answers

Dinesh

  • Aug 19th, 2011
 

Use lookup stage...and choose reject option !
you will get the matched records in master output file(3,4,5,5) and unmatched in reject file(1,2,2,6,7).

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions