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
- 19126 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
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
pmscmd startworkflow -sv
can you please explain me pre session and post session options?
What is the difference between informatica 7.0 and 8.0?
Explain the scenario which compels informatica server to reject files?
what is index?how it can work in informatica
Briefly describe lookup transformation?
Mention some types of transformation?
what is Active lock explain
What are the new features of informatica 9.x developer?
What are the settings that you use to configure the joiner transformation?
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
Write the program through which the records can be updated?
Enlist the differences between database and data warehouse.
