| |
GeekInterview.com > Interview Questions > Data Warehousing > ETL
| Print | |
Question: Session Execution
Answer: What is the first one executed in a session? Is it the Truncate Target Table option or the Post SQL? Explain |
| June 06, 2008 06:37:18 |
#1 |
| nova84 |
Member Since: June 2008 Total Comments: 1 |
RE: Session Execution
|
Truncate Target table:
Integration Service truncate target tables before running a session.Depending on the target database and primary key-foreign key relationships in the session target, the Integration Service might issue a delete or truncate command.
Post -SQL :
Enter post-session SQL commands to execute commands against the target database after the Integration Service writes to the target. |
| |
Back To Question | |
