Can someone point to detailed discussion on the events related to loading, such as:
Start Routine is exectued before each data package, or entire load?
Update rules are applied row by row or the entire KYF column in a data package is processed first?
When is delta determined, before Start Routine is executed, or, after it is executed, and before update rules are applied? This is important to know if we are dropping records from the data package.
If you have the answers, would love to hear and appreciate.
P.S. I always award points.