Search This Blog

SSIS

Execute SQL Task vs OLEDB Command Transformation

Get link
Facebook
X
Pinterest
Email
Other Apps

January 17, 2022

Execute SQL Task:

Comes under Control flow

Batch Operation

OLEDB Command Transformation:

Comes under Data Flow

Row by Row Operation

Get link
Facebook
X
Pinterest
Email
Other Apps

Comments

Explain the Percentage and row sampling Transformations?

April 04, 2022

This transformation will take data from the source and randomly sampling data. It gives you 2 outputs. First is selected data and the second one is unselected data. It is used in a situation where you train a data mining model. These two are used to take the SAMPLE of data from the input data.

What is Connection Mangers

February 09, 2017

Connection as its name suggests is a component to connect to any source or destination from SSIS — like a sql server or flat file or lot of other options that SSIS provides. Connection manager is a logical representation of a connection. Connection Managers are used for gathering data from various sources and sending it to a destination. It facilitates system connection by including information regarding server, data source, authentication details, database, etc.

What is Transformation? Explain Different Types of Transformations

February 28, 2017

Data transformation is the process of extracting required data from a data source and is the most critical SSIS step. Post extraction, the process aids in managing and transferring the data to a specific file destination. There are several rules implemented by this process for loading the extracted data to the destination target file. Based on this, the transformations are classified as: Blocked Non Blocked Semi Blocked Non-Blocking – No blocking Partial Blocking – The downstream transformations wait for certain periods, it follows start then stop and start over technique Full Blocking : The downstream has to be waiting till the data has been released from the upstream transformation. Non- blocking transformations Audit Cache Transform Character Map Conditional Split Copy Column Data Conversion Derived Column Export Column Import Column Lookup Multicast OLE DB Command Percentage Sampling Script Component Slowly Changing Dimension Partial blocking transforma...