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

» Database Journal Home
» Database Articles
» Database Tutorials
MS SQL
Oracle
DB2
MS Access
MySQL
» RESOURCES
Database Tools
SQL Scripts & Samples
Links
» Database Forum
» Sitemap
Free Newsletters:
DatabaseDaily  
News Via RSS Feed


follow us on Twitter
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

Comment and Contribute

 


(Maximum characters: 1200). You have characters left.

 

 




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