Loading columns in the target database

[yaminids]

Hello there,

I am trying to load the columns of a table in the target database. The problem is that some of these columns get data from one table and the remaining columnns from a different table. Is there any way that I could load some columns first and later on load the remaining columns from a different table.

Thanks in advance.
-yamini

[ray.wurlod]

Of course there is, and you do it the same way you'd do it with SQL.

Insert the first batch of rows, with suitable default values for those columns to be loaded in the second pass.

In the second pass, update the rows with appropriate column values, but only for the columns you need to update.

In this design, the first pass may need additionally to record the key values of the rows that it populated, so that these can be used for the second pass.