Answer Posted / usha

by using dynamic lkp its possible...

in dynamic lkp if we r having 2 records..
i will inser 1st record and will update second record...

when ever data inserted in to the target cache get
refreshed..

we ttake dynamic lkp..
by defaul..new lkp row port is added...

we should enable the associatve port...

here we should give the condition ..


in router we should give condition as newlkp=1--it will
insert...

if newlkp=0 means duplicate recorts

How are the sources and targets definitions imported in informatica designer?

1090

---

What is xml source qualifier transformation in informatica?

1205

---

How to load a Dimension ? and how to load a fact table?

1402

---

What are junk dimensions?

1058

---

In informatics server which files are created during the session rums?

1106

---

How to extract sap data using informatica? What is abap? What are idocs?

1159

---

r u done any partitions in ur project?

1810

---

I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.

1618

---

Make a note of the quantity vaults made in informatica?

971

---

How to delete duplicate row using informatica?

1019

---

How many ways are there to do 'remove duplicate records in informatica'?

989

---

What are the different options available for update strategy?

990

---

Under what condition selecting sorted input in aggregator may fail the session?

1111

---

What do you mean by channel change?

1022

---

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

1141

---