Answer / sehaj

DUPLICATE DATA CANOT B INSERTED USIN DYNAMIC LOOK UP
CACHE..BCOZ DYNAMIC LOOK UP CACHE PERFORMS ONLY UPDATE N
INSERT FUNCTION BASED ON THE KEYS IT GETS IN THE TARGET
TABLE N LOOK UP TABLE...

Answer / ankur saini er.ankur861@gmail.

we use dynamic lookups in case we have duplicates in source
and source says that they cnt remove them as per
requirement ...in that case we have to settle for:
say we have a reocrd id=1 , name=a
id=1 , name=b
so depending upon the PI id this is a duplicate so using
dynamic lookup when firts record comes the lookup cache
will have id=1 , name=a
again will duplkicate row will come then it gets updated to
id=1 , name=b
so finally only last record from the quplicates will be
lloaded in the target

can session assigned multiple mappings or not?

2 Answers   Zensar,

---

If we have 1000 rows were loaded in to datawarehouse and next day the source have 1010 rows so, how can we loaded only updated rows into target.

6 Answers   Accenture,

---

my source is junk data how will u remove that junk data by using unix please any one replay me

0 Answers   Cap Gemini,

---

wat are deployement groups in informatica, how it will be used for developers

0 Answers  

---

What is union transformation in informatica?

0 Answers  

---

Informatica settings are available in which file?

0 Answers   Informatica,

---

what is casual dimension?

6 Answers   IBM,

---

What do you understand by term role-playing dimension?

0 Answers  

---

What are the mapings that we use for slowly changing dimension table?

2 Answers  

---

Why is meant by direct and indirect loading options in sessions?

4 Answers  

---

can you use flat file for repository?why?

2 Answers   TCS,

---

Can we update a target table (without primarykey) by using update strategy transformation?

4 Answers   TCS,

---