Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Tips Database Forum Rss Feed

» Database Journal Home
» Database Articles
» Database Tutorials
MS Access
SQL Scripts & Samples
» Database Forum
» Slideshows
Free Newsletters:

News Via RSS Feed

Rss Feed

Database Journal |DBA Support |SQLCourse |SQLCourse2

Featured Database Articles

Database News

Posted Feb 4, 2009

SSIS - An Inside View Part 2

By DatabaseJournal.com Staff

[From SQL Server Performance]

Transformation and Execution Tree
Synchronous transformation/component

A synchronous transformation processes incoming rows and passes them on in the data flow one row at a time. Output is synchronous with input, meaning that it occurs at the same time. Therefore, to process a given row, the transformation does not need information about other rows in the data set. In other words, when a transform can modify the row in place so as to not change the physical layout of the result set, then it is said to be a synchronous transform. The output of a synchronous component uses the same buffer as the input and do not require data to be copied to a new buffer to complete the transformation. Reusing of the input buffer is possible because the output of a synchronous component usually contain the same number of records as the input, it means each output row has a 1:1 relationship with an input row (though you can use the redirect method to conditionally out rows to different outputs as the multicast and conditional split transformations do).

The article continues at http://www.sql-server-performance.com/articles/biz/SSIS_An_Inside_View_Part_2_p1.aspx

Database News Archives

Latest Forum Threads
Database News Forum
Topic By Replies Updated
Efficient SQL Server Indexing by Design lcole 0 April 30th, 12:38 PM
Mine Oracle Database, SQL Server and Other Databases with Monarch Data Pump Pro V10.5 lcole 0 April 30th, 12:37 PM
Oracle Database and Oracle Fusion Middleware for Private Social Network Application lcole 0 April 30th, 12:31 PM
Oracle Database Maintains a Stronghold in the DBMS Market lcole 0 April 30th, 12:30 PM