Answer Posted / kish

Hi Krishna,

i think you r wrong...he is asking abt flat file...
by using LOOKUP we can eliminate duplicates...
You can eliminate duplicates and can capture that duplicates
using
dynamic lookup cache. look up the target table if New lookup
row=0 then it is unchanged (duplicate
record) SEND TO ONE TARGET

What is the use of code page?

617

---

Differentiate between Load Manager and DTM?

1684

---

How can we handle two sessions in informatica?

627

---

How to do the error handling of if ur source is flatfiles?

1519

---

How do you load only null records into target? Explain through mapping flow.

1511

---

---

What is a dimensional model?

587

---

How to update source definition?

643

---

What are the components of the workflow manager?

648

---

Is it possible to use a client with different version than that of its Informatica server?

655

---

How to Create a folder using pmrep command?

629

---

What the difference is between a database, a data warehouse and a data mart?

603

---

What is deployment group?

694

---

pmscmd startworkflow -sv -d -u -p -f while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?

1062

---

What is aggregate cache in aggregator transformation?

643

---

What is the session task and command task?

608

---