linking tables in target database

[yaminids]

Hello there,

Can anyone explain to me how to link two or more tables in the target database with a common column 'A'. Actually I am populating this(common) column in a table and tying to link this column with the other two tables.

Thanks in advace.
-Yamini

[ray.wurlod]

Not sure what you mean by "link".

In DataStage, there is no awareness of relationships between tables, though this information is captured when you import a table definition.

Effectively you have two choices.

• You can update both tables in the one job, putting the same value into column A in each table.
  
  You can update column A in table 1 in one job then, in a second job, pre-populate a hashed file with sufficient information to allow the correct value to be loaded into column A in table 2.