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.

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

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?

6 Answers   Thomson Reuters,

---

what are cost based and rule based approaches and what is the difference?

1 Answers  

---

what happens when a batch fails?

3 Answers  

---

Explain why we use partitioning the session in informatica?

0 Answers  

---

Hi ETL gurus can any one tell me with a flow how to implement SCD Type 1 and SCD Type 2 in a single mapping.For some fields SCD type has to be implemented and for some fields scd type has to be implementd..Thank in advance..please let me know in case of any concerns...

1 Answers  

---

How to generate the HTML output using Informatica.

3 Answers   Wipro,

---

What are the tasks that source qualifier performs?

1 Answers  

---

what is the difference between Informatica7.1 & informatica 8.1

4 Answers  

---

How will you update the row without using update statergy?

10 Answers   CTS,

---

Diffrence between 7.1,8.1 and 8.6

3 Answers   HCL, Wipro,

---

What are limitations of joiner transformation?

2 Answers   Exilant, TCS,

---

What do you mean by blocking transformation?

0 Answers  

---