Suggest the job design

[bkumar103]

Hi,
I have to design a job for the following problem.

There are two table say table1 and table2. Table1 refrences table2 by Foreign key relationship.
Is there any possible way to load these two table simultaneously in one job?

Please suggest me any alternative.

Thanks in advance.

Birendra

[savis]

Since table 1 references table2 by foreign key relationship, You cannot load both tables simultaneously.
Table 2 should be completely loaded before you start loading table 1.

Use a sequencer, load table 2 in a separate job. Once it is done, load table 2 in a second job.

[ray.wurlod]

Not really. You have to ensure that the parent record (in the referenced table) is in place before writing any child record (in the referencing table).

The only exception is when you use the Slowly Changing Dimension stage (version 8.0 and later), which manages this for you.