difference between source based commit? and target based
commit? which is better with respect to performance?
Answer Posted / srinu
source based commit,Target based commit
Both are Having the Same importence.
You can go for commit based on Importence,Requirement only.
If your source have limit then go for source based commit,
If your Target have limit then go for Target based commit.
Any ??? or Corrections,,let me know
‘Srinu.srinuvas@gmail.com ‘
| Is This Answer Correct ? | 8 Yes | 4 No |
Post New Answer View All Answers
What is a passive transformation?
Explain transaction control transformation in informatica
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
Differentiate between Load Manager and DTM?
What is a grid in Informatica?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
How to extract sap data using informatica?
What is a rank transform?
what is diff b/t sorter t/r and agg have the option sorter property...
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
How can we delete duplicate rows from flat files?
How to use pmcmd utility command?
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
What is a joiner transformation?
Can we override a native sql query within informatica?