difference between source based commit? and target based
commit? which is better with respect to performance?
- 6 Answers
- 17102 Views
- IBM, I also Faced
- E-Mail Answers
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 |
when do we use static cache and when do we use dynamic cache in lookup transformation? with example.
My source contains 10 records with 5 columns.What happens if I select group by all columns in Aggregator T/R?
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
my source contain data like this cno cname sal 100 rama@gmail.com 1000 200 karuna@yahoo.com 2000 i want load my data to the target is cno cname sal 100 rama 1000 200 karuna 2000 plz send the answer
Q. In source area, it is use complex query we have using 5 to 10 table we has been join now all join clolumn having indexes but still we having performance issue. how to fix the performnce issue of the query.
can we import source table without using source qualifier? if yes then how? if no then why?
What is workflow manager?
insallation procedure for power center 8.1.1 especialy domain_config hw to use parameter files
i have 1000 records in my dource table, the same i have in target ,but a new column added in target as "batchno", and this column adds no 10 for 1st 100 records and 20 for next 100 records and 30 next 100 records and vice versa. how to acheive this?
HI Experts, What is BULK mode and NORMAL mode, Which one gives better performance. How? Please Explain with an example...! It will help's me a lot. Thanks In advance.
Hi,tell me the system testing and Integration Testing in the Informatica ? Thank You
update strategy transformation in informatica
Teradata 
