SSIS Interview Questions 11

· 1 min read

SSIS

Questions:Notes:
What is Required?Required is where the container starts a new transaction. If an existing transaction has already been started by the parent container, the container will join it.
What is Data Blocking?Data Blocking is where data in the pipeline is held up by a transformation operation. It blocks the flow of data to subsequent components downstream.
What are Blocking Transformations?Blocking Transformations are transformations that require all input rows to be read before they can process the data are blocking transformations. These include: Aggregation Sort Fuzzy Grouping Fuzzy Lookup
What are Partially Blocking Transformations?Partially Blocking Transformations are transformations that have multiple data inputs and their resulting output may have a different number of records from the total number of input records. They include: Merge Merge Join Pivot Unpivot Union All Term Lookup Data Mining Query

Share this post