difference between source based commit? and target based
commit? which is better with respect to performance?
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
what is $$$$?
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
What are the new features of informatica 9.x developer?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
can anyone suggest best free Talend data integration training online
Could you explain what is enterprise data warehouse?
explain one complex mapping with logic? sales project?
In informatica workflow manager, how many repositories can be created?
What is data transformation manager process?
What can we do to improve the performance of informatica aggregator transformation?
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
While importing the relational source definition from the database, what are the metadata of source that will be imported?
is it possible to index the data in cache of lkp transformation ?
In development project what is the process to follow for an etl developer from day1
How we can create indexes after completing the loan process?