What happens if you increase commit intervals and also
decrease commitExplain grouped cross tab?
Answers were Sorted based on User's Feedback
Answer / sasikumar_bes
if you have increased your commit interval to ~25000 rows
the session will run faster but when your session fails at
24000th record you will not have any data in your target.
When you decrease your commit interval to ~10000 rows your
session will be slow when compared to previous but if the
session fails at 24000th record you will lose only 4000
records.
Is This Answer Correct ? | 12 Yes | 0 No |
Answer / anju
if commit interval is set to high value, performance will
be high. if commit is given for every 1000 rows say for eg,
it will affect the performance badly
Is This Answer Correct ? | 6 Yes | 0 No |
how i will stop my workflow after 10 errors
What are the different options used to configure the sequential batches?
Source (Flatfile) - Target (1-1 mapping). How to load first or last 20 record to target?
Hello Everyone,i have one question on sequence generator.i have two targets and the records comes from the source will place in the targets like 1-10 rec in target1 and 11-20 rec in target2,21-30 rec in target1...etc so any one can help me? plz..Thanq in adv.
what is the method of error handling when session is running?
How do you change a non-reusable transformation to reusable transformation?
Which is better performance wise database or file?How?
how you will maintain version?
Plz..let me know differences between Informatica 7.1 and 8.1?
i have flatfile source. i want to load the maximum salary of each deptno into target. what isthe mapping flow
By using Filter Transformation,How to pass rows that does not satisfy the condition(discarded rows) to another target?
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?