If you want to run a second session only if the first session completes successfully, then which task you should use?
Can you run part of work flow?
Which tasks are re-usable?
Which task Waits for a user-defined or a predefined event to occur, once the event occurs, the Integration Service completes the rest of the workflow?
If you want to copy the rejected files and paste it in other directory during the running of work-flow, then which task you should use?
Which one is not a commit type?
What are the types of method to load dimensional table?
What is lookup table?
Whch scd type stores one time historical data with current data?
Which SCD method tracks historical data by creating multiple records?
What is hybrid SCD?
Which schema is normalized?
If one table contains a value that is not either measure or fact, what do we call that?
Which type of wizard loads a static fact or dimension table by inserting all rows?