|
Data Warehouse |
|
|
[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:
|
|
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:
|
