Interested to Buy Any Domain ? << Click Here >> for more details...
difference between source based commit? and target based
commit? which is better with respect to performance?
- 6 Answers
- 19061 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 |
How can we use batches?
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
My source contains 10 records with 5 columns.What happens if I select group by all columns in Aggregator T/R?
How to use Normalizer transformation?
tell me the informatica architecture
After a load is done to my target table, I need to insert a last row, which might be formed at some expression transformation and brought to target. Do I have to have separate mapping to be run after the 1st mapping? Or in a single mapping how to achieve this?
difference between informatica 8.1.1 and 8.6? And different betweeninformatica 7x and 8x?
why normalizer transformation can not used in mapplet? plzzzz answer
TWO FLAT FILES ARE THERE , EACH HAVING NO MATCHING COLUMNS . HOW CAN U JOIN THESE TWO USING JOINER TRANSFORMATION ?
Why can't we connect 2 active transformations to an active transformation ? Ex:- One aggriagator and one sq trans to an router transformation
What is the approximate size of data warehouse?
6 Answers Accenture, i3 Solutions,
how many types transformations supported by sortedinput?
Teradata 
