Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.
Moderators: chulett , rschirm , roy
ann
Participant
Posts: 19 Joined: Thu Jan 06, 2005 12:02 pm
Post
by ann » Thu Jun 02, 2005 6:29 am
hi all,
i have to update a target table with source table values comparing t table primary keys (2) to s table 2 cols which are not primary keys. can anyone help me how to compare them.
thanks,
ann
Sainath.Srinivasan
Participant
Posts: 3337 Joined: Mon Jan 17, 2005 4:49 am
Location: United Kingdom
Post
by Sainath.Srinivasan » Thu Jun 02, 2005 8:31 am
If they are in the same db, you can use a NOT IN clause.
Otherwise, you can do a lookup against the target. You can improve performance later.
ann
Participant
Posts: 19 Joined: Thu Jan 06, 2005 12:02 pm
Post
by ann » Thu Jun 02, 2005 9:00 am
hi sainath,
thanks for reply. I am verry new to datastage. cn u please elaborate how to do lookup.
thank u
Sainath.Srinivasan
Participant
Posts: 3337 Joined: Mon Jan 17, 2005 4:49 am
Location: United Kingdom
Post
by Sainath.Srinivasan » Thu Jun 02, 2005 10:20 am
To do a lookup, you need a source link and a reference link.
The datastage manual gives you step-by-step explanation and method to achieve this.
If you still have any doubt after reading and trying the same, let us know.
ann
Participant
Posts: 19 Joined: Thu Jan 06, 2005 12:02 pm
Post
by ann » Thu Jun 02, 2005 12:22 pm
thank u Sainath. I will read it again and try the method.
Anantha.
ray.wurlod
Participant
Posts: 54607 Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Post
by ray.wurlod » Thu Jun 02, 2005 4:18 pm
You might also benefit from reviewing the Lookups section in the tutorial that ships with DataStage.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.