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 |