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

What is an active transformation?

0 Answers   Informatica,

---

If a workflow stops or fails after loading 10k records ? How can you recover it and If there is no order while reading data from source ?

2 Answers   IBM, WalMart,

---

Create a mapping which contains 2 target tables. When the session runs for the first time it shud load Target table 1 and when it runs for second time it shud load Target table 2.

7 Answers   TCS,

---

can u apply SCD2 on flat file tgt? if yes wat is the procedure?

3 Answers   Deloitte,

---

what is the -ve test case in your project.

0 Answers   CTS, TCS,

---

What is the reusable transformation?

0 Answers  

---

yesterday my session run ten min.today its run 30min, wt is the reason? if any issues how to solve that?

2 Answers   iGate,

---

How to extract the informatica rejected data?

0 Answers  

---

Define Update Override?

1 Answers  

---

what are the output files that the informatica server creats during running a session?

2 Answers   CTS,

---

Which kind of index is preferred in DWH?

3 Answers  

---

difference between source based commit? and target based commit? which is better with respect to performance?

6 Answers   IBM,

---