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
COM components can be used in Informatica
What are the measure objects?
What is Session and Batches?
4 yrs etl devloper roles and responsibilities?any body give solutions
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
What are the limitations of joiner transformation?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
What is the way to execute pl/sql script using informatica mapping?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
Mention few power centre client applications with their basic purpose?
Under what condition selecting sorted input in aggregator may fail the session?
What are the guidelines to be followed while using union transformation?
Performance tuning in UNIX for informatica mappings?
In how many ways we can create ports?
What is a sorter transformation?