difference between source based commit? and target based
commit? which is better with respect to performance?
Answers were Sorted based on User's Feedback
Answer / vamsi
Encourage the person who is trying to give some answers,try
to learn the subject not the english.
Is This Answer Correct ? | 54 Yes | 1 No |
Answer / versch
agree with Vamsi. the person who doesnt know you name know
better than you. Atleast he is answering the questions for
others benefit. Stop making such rekmarks. This panel is
for self-hel and helping others for interview.
Grt job Vamsi!! Keep up.
Is This Answer Correct ? | 21 Yes | 1 No |
Answer / 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 |
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 |
Answer / infanewbee
i am new in Informatica ....................what does dropped means here(since 400 dropped/rest of 500 dropped) ??
Is This Answer Correct ? | 0 Yes | 1 No |
Answer / krithi
Srinu,please learn how to write grammatically correct
english :-)
Is This Answer Correct ? | 6 Yes | 38 No |
In any project how many mappings they will use(minimum)?
What is domain in terms of informatica?
Can we use Lookup instead of Joiner to join 2 tables? If yes which is faster and why?
Flat file heaving 1 lack records and I want to push 52000 records to the target?
why we are using surogate key in real time give me explanation
Lookup transformation, one condition is having SQL override (Empno < 10) and the other condition is Lookup (Sal>1000), which is dynamic. How will u resolve this situation?
source table have single column single record having with single space. load that source record into trg . trgt having two columns and the SOURCE TABLE LIKE COL1 BHANU PRASAD TRGT TABLE COL1 COL2 IN THAT LOAD THE RECORD IN THE trgt table LIKE COL1 COL2 BHANU PRASAD HOW ? TELL ME PLZ
Explain incremental aggregation in informatica
How can we join the tables if they don't have primary and foreign key relationship and no matching port?
comonly how meny mappings r there in Banking projects?
I have a condition sal=100 and I created one router and in that two groups g1 and g2 in g1 Sal<=100 and g2 Sal>=100, first which condition will satisfy, and Why?
where to select code page option?