| |
GeekInterview.com > Interview Questions > Data Warehousing > Informatica
| Print | |
Question: Suppose session is configured with commit interval of 10,000 rows and source has 50,000 rows. Explain the commit points for Source based commit and Target based commit. Assume appropriate value wherever required.
|
| May 05, 2008 12:54:40 |
#2 |
| vivek1708 |
Member Since: May 2008 Total Comments: 18 |
RE: Suppose session is configured with commit interval of 10,000 rows and source has 50,000 rows. Explain the commit points for Source based commit and Target based commit. Assume appropriate value wherever required.
|
I dont think above written statement is correct
Myunderstanding is that
for source based commit: a session as soon as it reads 10k rows from the source it performs a commit
and similarly for tbc: as soon as it write 10k rows to targt it does a commit |
| |
Back To Question | |
