What happens if you increase commit intervals and also
decrease commitExplain grouped cross tab?
Answer Posted / anju
if commit interval is set to high value, performance will
be high. if commit is given for every 1000 rows say for eg,
it will affect the performance badly
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
Where are the source flat files kept before running the session?
What is a dimensional model?
What is a filter transformation and why it is an active one?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
What are data-driven sessions?
What is domain in terms of informatica?
What is workflow monitor?
How do you convert single row from source into three rows into target?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
What are the various types of transformation?
In informatics server which files are created during the session rums?
Performance tuning in UNIX for informatica mappings?
Can informatica load heterogeneous targets from heterogeneous sources?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
What is target designer and target load order?