| |
GeekInterview.com > Interview Questions > Data Warehousing > Informatica
| Print | |
Question: what is difference between source base and target base commit
|
| May 05, 2008 05:44:29 |
#1 |
| pravaccet |
Member Since: May 2008 Total Comments: 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. |
| |
Back To Question | |
