| |
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.
|
| June 06, 2008 00:37:32 |
#3 |
| prade |
Member Since: May 2008 Total Comments: 4 |
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.
|
In case of a source based commit, the integration services generates a commit row from the active sources and writes the rows into the target. The number of rows processed from the "active source" is the driving factor in commit intervals. If the "active source" processes 10,000 rows out of which 2000 are discarded due to mapping logic then only 8000 rows are committed else all 10,000 are committed. If the session completes successfully then the commit points are 10k, 20k, 30k, 40k and 50k.
It should be noted here that "active sources" are not always the source qualifiers and it is the transformation to the target with all input transaformation scope in the line of the transactional unit.
Incase of a mapping with two transactional units and a single SQ
SQ----> AG ------> Target1
----->FILTER----> target2
for target1 AG is the commit source whereas for target2, Filter is the commit source |
| |
Back To Question | |
