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 do you mean by filter transformation?
expain about the tune parameters?
What is the use of an aggregator cache file?
What is union transformation?
Where are the source flat files kept before running the session?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
How can we handle two sessions in informatica?
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
what are 3 tech challenges/ common issues you face?
What is aggregator transformation in informatica?
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
What is an expression transformation?
Which are the different editions of informatica powercenter that are available?