When will u go for Dynamic Cache and Persistent Cache? Pls explain with an example?

2 Answers   TCS,

---

What is the difference between router and filter?

0 Answers  

---

What is parameter file?

2 Answers  

---

What is complex mapping?

0 Answers  

---

Hi I have two sources like A, B. My source A contain 10000 million records from that i need 20 attributes. My source B has also same 10000 million records from that i need only 1 attribute. By using Joiner i have to load into target? Is there any issue regarding this? if issue is there how to tune this mapping in best way?

2 Answers   Zensar,

---

How to load last 10 records of flat file in to the target?

5 Answers   iNautix,

---

How do you load alternate records into different tables through mapping flow?

0 Answers  

---

Roles and Responsibilties of Informatica Production Support Member?

6 Answers  

---

how to run 2 workflows sequentially. plz respond what is the process?

9 Answers   Cap Gemini, Target,

---

Suppose we have a (assume relational) source table Product_Id Month Sales 1 Jan x 1 Feb x . . . . . . 1 Dec x 2 Jan x 2 Feb x . . . . . . 2 Dec x 3 Jan x 3 Feb x . . . . . . 3 Dec x . . . . . . and so on. Assume that there could be any number of product keys and for each product key the sales figures (denoted by 'x' are stored for each of the 12 months from Jan to Dec). So we want the result in the target table in the following form. Product_id Jan Feb March.. Dec 1 x x x x 2 x x x x 3 x x x x . . So how will you design the ETL mapping for this case , explain in temrs of transformations.

5 Answers   Accenture, VAMA,

---

What is Datadriven?

2 Answers   Informatica,

---

how can i invoke pmcmd in command line prompt

1 Answers  

---