pravaccet

 Profile Answers by pravaccet 

• May 22nd, 2008

 

For instance consider that if there are 50000 rows in the source and if you give the commit type as source with interval 10000, the powercenter server reads 10000 rows from the source as committed records and inserts into the target.

If you choose target base commit, The server reads all the records(50000) from the source and while inserting into the target it will try to insert 10000 records into the target as committed records.

ggazulas

 Profile Answers by ggazulas 

• May 27th, 2008

 

Suppose if we say the target base commit as 1000, then informatica server will apply commit for every 1000 on the target table.

if we say a source base commit for 1000, and due to tranformation logic suppose 500 rows are dropped, then only 500 rows will insert into the target table, informatica server will apply commit on those 500 rows.

etl.king

 Profile Answers by etl.king 

• Sep 29th, 2008

 

Target based commit:              commit Intervel 1000


Target based commit intervel based on buffer level. For example buffer able to contains 1500 records means the integaration server fill the buffer level 100 .. 200 .. upto 1000 but the but the buffer level is 1500 so the integration server continuesly fill the buffer up to 1500 and issue the commit command so the commit command issued by server is differ from commit intervel

First command -1500
second command -3000


source based commit : It is based on actve transformation in the mapping . It may be differ from commit intervel


If it is not correct  please let me know the correct answer.

av_ashish

 Profile Answers by av_ashish 

• Oct 17th, 2008

 

These are the 3 types of commits possible in INFA

• Target-based commit. The PowerCenter Server commits data based on the number of target rows and the key constraints on the target table. The commit point also depends on the buffer block size, the commit interval, and the PowerCenter Server configuration for writer timeout.
• Source-based commit. The PowerCenter Server commits data based on the number of source rows. The commit point is the commit interval you configure in the session properties.
• User-defined commit. The PowerCenter Server commits data based on transactions defined in the mapping properties. You can also configure some commit and rollback options in the session properties.

gaurav2485

 Profile Answers by gaurav2485 

• Jan 8th, 2009

 

Suppose we have choose 10000 source to be commit
Source based Commitment is it will read 10000 rows and pass through many transformation (active and passive) so upto what out of 10000 rows it reaches the target it will commit

And if we have 10000 target to be commit
Target based Commitment is suppose writer has buffer of 7500 rows so it will read till 7500 rows and write that to target but it won't commit and then when writter buffer will be again fill with 75000 it will commit to target(total 15000) so it will goes like that