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
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
What are the features of complex mapping?
Enlist some properties of sessions.
What is data transformation manager process?
How to update source definition?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What is the difference between router and filter?
What do you understand by term role-playing dimension?
How can we update a record in the target table without using update strategy?
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
What is the difference between source qualifier transformations source filter to filter transformation?
What is domain and gateway node?
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
How to use pmcmd utility command?