table x has a1,b1,c1 and table2 has a1,d1,e1

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
dssubhani
Participant
Posts: 38
Joined: Wed Jul 14, 2010 11:12 pm

table x has a1,b1,c1 and table2 has a1,d1,e1

Post by dssubhani »

table1 has a1,b1,c1 and table2 has a1,d1,e1...........

now i want table2 only in which table1 values should not be there ......how?
subhani
anbu
Premium Member
Premium Member
Posts: 596
Joined: Sat Feb 18, 2006 2:25 am
Location: india

Post by anbu »

Use lookup stage. Keep table2 as main table and table1 as reference. Reject link of lookup stage gives what you want.
You are the creator of your destiny - Swami Vivekananda
Post Reply