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

What are the new features of informatica 9.x developer?

1 Answers  

---

How can i catch the Duplicate Rows From SorterTrans in a Seperate Target Table ?

2 Answers  

---

where is the reject loader .

1 Answers  

---

I am hvaing SOURCE as 1000,null,null,null null,2000,null,null null,null,3000,null null,null,null,4000 Now i want the OUTPUT as 1000,2000,3000,4000 For more clarification i want to elimate nulls and want in a single line. Please help me out

5 Answers   IBM,

---

Two Default User groups created in the repository are ____ and ______

2 Answers  

---

How to load a relational source into file taget?

2 Answers  

---

what is mapping parameter?

2 Answers   Cap Gemini,

---

explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?

1 Answers   TCS, Wipro,

---

why sequence generator should not directly connected to joiner transformation ?

1 Answers   ANZ,

---

What are the scheduling options to run a sesion?

2 Answers  

---

Stage is which type of load is it a full load or incremental load Please let me know in detail with best example

3 Answers   Infosys,

---

What is update override?

1 Answers   Accenture,

---