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
- 18890 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
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
Explain in detail scd type 2 through mapping.
How do you take back up of repository?
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
How to create a non-reusable instance of reusable transformations?
What are the guidelines to be followed while using union transformation?
What's the layout of parameter file (what does a parameter file contain?)?
Enterprise data warehouse your projects phase by phase explain?
What is the use of code page?
What are the differences between source qualifier and joiner transformation?
What is status code in informatica?
Define sessions in informatica etl?
Make a note of the quantity vaults made in informatica?
How will the document be delivered to me?
What is joiner transformation?
