difference between source based commit? and target based
commit? which is better with respect to performance?
Answer Posted / 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 |
Post New Answer View All Answers
How do you migrate data from one environment to another?
What is the fact table?
Can you use flat files in Mapplets.
How does a rank transform differ from aggregator transform functions max and min?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
list out all the transformations which use cache?
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
Where are the source flat files kept before running the session?
can u any challenge your project?
What is deployment group?
What is Cognos script editor?
Suppose we do not group by on any ports of the aggregator what will be the output?
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
Explain sessions and how many types of sessions are there?
Reusable transformation and shortcut differences