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

If you have 10 mappings designed and you need to implement some chages (may be in existing mapping or new mapping need to be designed) then how much time it takes from easier to complex?

1 Answers  

---

What do you mean by filter transformation?

0 Answers  

---

in which situations do u go for scds ?

3 Answers   TCS,

---

What is a configuration management?

1 Answers  

---

explain abt union t/r?

1 Answers   IBM,

---

---

Can we create out put ports in source qualifier t/r?

5 Answers   TCS,

---

how to get max value record into one target and remaining records into another target?

2 Answers   Accenture,

---

i have thousand records in my source(flat file) i wanna load 990 records i don't want load first 5 records and last 5 records at informatica level?

3 Answers   Satyam,

---

What are the associated ports in look up T/R.

5 Answers   IBM, Zensar,

---

How do you implement configuration management in Informatica?

1 Answers  

---

Hi Every One When i Start the Workflow, Table is Going to be Stored in the target database But the columns are not going to the target database table in my PC , please give me the solution and waiting for solution

2 Answers  

---

what is the architecture of any Data warehousing project?

5 Answers   IBM,

---