what is meant by Initial Load & Delta Load..?
when does it come into picture in Datastage ?
Initial Load in Datastage?
Moderators: chulett, rschirm, roy
Initial Load in Datastage?
Sudheer
-
ray.wurlod
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.