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

In development project what is the process to follow for an etl developer from day1

0 Answers  

---

how to identify new and old values in source qualifier or any other transformations using informatica

2 Answers  

---

What does update strategy mean, and what are the different option of it?

0 Answers  

---

I am having two tables,say table1 having cols Empid,firstname,lastname,middlename and table2 having Empid,firstname,lastname can i union them using Union t/f?

6 Answers   Accenture,

---

I have source table 100 records after run session successfully but loads the target table 50 records only what happened that 50 records and how can i load remaining 50 records

5 Answers   Patni,

---

what is materialized view?

2 Answers  

---

What are the issues that you have faced while moving your project from the Test Environment to the Production Environment?

1 Answers  

---

i want to load data in to two targets..one is dimension table and the other is fact table?how can i load ata a time

3 Answers   iGate,

---

WHAT IS UPDATE OVERRIDE . DIFFERENCE BETWEEN SQL OVERRIDE AND UPDATE OVERRIDE ?

7 Answers   Target,

---

What is the filename which you need to configure in UNIX while installing infromatica?

2 Answers   Accenture,

---

How many input parameters can exist in an unconnected lookup?

0 Answers  

---

What is diff joiner and lookup

4 Answers   BirlaSoft,

---