DSXchange

what is meant by Initial Load & Delta Load..?

when does it come into picture in Datastage ?

When's the interview?

These terms can mean different things in different scenarios, but I shall assume you are referring to some kind of ETL context.

The initial load is where the target table is empty at the start of the run. Delta loads compare the new data with what's already in the table and only load the changes.

How this is actually done depends on what kind of change is detected (insert, update or delete) and whether surrogate key management is required.