|
Data Warehouse |
|
|
[SSIS] |
|
|
Questions: |
Notes: |
|
What are Non-Blocking Transformations? |
Non-blocking Transformations are transformations that work with only individual field values for rows in the pipeline, they can transform the data row by row. A transformation with this requirement can begin to process data as it flows to it and will make processed rows available down the pipeline as they are processed, and data can stream through this transformation. This process is synchronous and does not block the next transformation in the pipeline.
They include:
|
|
What are Synchronous Components? |
The output of a synchronous component uses the same buffer as the input. Reusing of the input buffer is possible because the output of a synchronous component always contain exactly the same number of records as the input.
Number of records IN == Number of records OUT. |
