What is source based commit?
Ans:- The Integration Service commits data to the target based on the number of rows from some active sources in a target load order group.
What is One-to-One mapping?
Ans:- One-to-one mapping is a mapping that moves data from a Source Qualifier, XML Source Qualifier, or Application Source Qualifier transformation directly to a target. Source-based commit may slow session performance if the session uses a one-to-one mapping.
What is commit source?
Ans:- The Integration Service uses the commits generated by the active source that is closest to the target definition. This is known as the commit source.
What is Single Commit Source ?
Ans:- In single commit source – only one active source generate the commits – which can be either a source qualifier or transformation (that do not propagate transaction boundaries) that is closest to the target definition.
What is Multiple Commit Sources?
Ans:- In multiple commit source – More than one active source generate the commits – which can be either a source qualifier or transformation (with scope All Input) that is closest to the target definition.
What will happen if the target does not receive commits from an active source that generates commits?
Ans:- If the Integration Service identifies a target in the target load order group that does not receive commits from an active source that generates commits, it reverts to target-based commit for that target only.
How to know which transformation used for source-based commit?
Ans:- The Integration Service writes the name of the transformation used for source-based commit intervals into the session log. When the Integration Service switches to target-based commit, it writes a message in the session log.
In what scenario a target might not receive commits from a commit source?
Ans:- If you have a XML source qualifier transformation connected to multiple output groups downstream, It will not generate commits.