Answer / hai

dynamic cache is there. LKP dynamic cache...........

Answer / vidya

s lkp transformation is having dynamic cache

Answer / pa1

Dynamic Cache is there for look up t/r. But we need to look
up only on targets

Answer / maheedhar

I have answered no,kindly correct if am wrong

how to join the 2 different table with different columns in informatica?

5 Answers   Accenture,

---

can you use flat file for lookup table?why?

2 Answers   HCL,

---

how to load dimension table and fact table. plz tell me the steps.

0 Answers   Cognizant, IBM,

---

Whats the difference between $, $$, $$$

9 Answers  

---

Slowly changing dimensions, types and where will you use them

0 Answers  

---

Where is metadata stored?

0 Answers  

---

Can we combine a flatfile and a database table using an UNION transformation?

2 Answers   Accenture,

---

what is constraint based load order

2 Answers   Cap Gemini,

---

Hi gurus can any one tell me with a flow how to implement SCD Type 1 and SCD Type 2 in a single mapping.For some fields SCD type has to be implemented and for some fields scd type has to be implementd..Thank in advance....

1 Answers  

---

on a day i load 10 rows in my target and on nextday i get 10 more rows add to my target but out of 5 are update row how ican send them to target?how i can insert and update the records

4 Answers   Fidelity,

---

I have a source as flat file and having data like ""TCS"MUMBAI" and i want output like TCS MUMBAI,the length of the data in the rows is variable.how can you fix it?

5 Answers   TCS,

---

Explain what are the different types of transformation available in informatica.

0 Answers  

---