Interested to Buy Any Domain ? << Click Here >> for more details...
difference between source based commit? and target based
commit? which is better with respect to performance?
- 6 Answers
- 19057 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / siva
If you set the source based commit, say 1000, it executes
commit after immediate of 1000 records read, irrespective
of how many rows passed to target (may be 600 since 400
dropped).
Similarly, if you set target based commit, say 1000, it
executes commit after immediate of 1000 records inserted,
irrespective of records read from source (may be 1500, rest
of 500 dropped)..
I think you got it..
| Is This Answer Correct ? | 6 Yes | 1 No |
Post New Answer View All Answers
Explain the shared cache and re-cache?
What is difference between a gateway node and worker node?
What is a repository manager?
How we can use union transformation?
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
What is transformation?
Tell me about MD5 functions in informatica
What does “tail –f” command do and what is its use as an Informatica admin.
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
Explain the different kinds of facts.
Under what condition selecting sorted input in aggregator may fail the session?
How to do unit testing in informatica?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
How to handle decimal places while importing a flatfile into informatica?
