comparing target cols with source cols

ann · 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 · 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 · 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 · 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 · 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 · 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.