Informatica - what is difference between source base and target base commit

GeekInterview.com > Interview Questions > Data Warehousing > Informatica

Go To First | Previous Question | Next Question

Informatica | Question 617 of 644

what is difference between source base and target base commit

Total Answers and Comments: 5

Last Update: January 08, 2009 Asked by: jinyjha

Sponsored Links

Best Rated Answer

—

Submitted by: ggazulas

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.

Above answer was rated as good by the following members:
manzuma, DK_Reddy

May 22, 2008 05:44:29

pravaccet

Member Since: May 2008 Contribution: 1

RE: what is difference between source base and target base commit

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.

Is this answer useful? Yes | No

1 1

Overall Rating: -N/A-

May 27, 2008 09:36:42

ggazulas

Member Since: May 2008 Contribution: 6

RE: what is difference between source base and target base commit

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.

Is this answer useful? Yes | No

1 1

Overall Rating: -N/A-

September 29, 2008 07:58:44

etl.king

Member Since: September 2008 Contribution: 1

RE: what is difference between source base and target base commit

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.

Is this answer useful? Yes | No

0 1

Overall Rating: -1

October 17, 2008 10:45:38

av_ashish

Member Since: October 2008 Contribution: 1

RE: what is difference between source base and target base commit

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.

Is this answer useful? Yes | No

0 1

Overall Rating: -1

January 08, 2009 04:46:26

gaurav2485

Member Since: January 2009 Contribution: 12

RE: what is difference between source base and target base commit

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

Is this answer useful? Yes | No

0 1

Overall Rating: -1

Go To Top

User Name		Remember Me?
Password

Question Bank