SSIS Interview Questions 12

· 1 min read

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: Audit Character Map Conditional Split Copy Column Data Conversion Derived Column Multicast Percent Sampling Row Count Script Task Input/Export Column SCD OLE DB Column
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.

Share this post