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,

---

Transformer is a __________ stage option1:Passive 2.Active 3.Dynamic 4.Static

2 Answers   Accenture,

---

how can we run workflow with pmcmd?

3 Answers   Wipro,

---

What will happen when Mapping variable and Mapping parameter is not defined or given? Where do you use mapping variable and mapping parameter?

10 Answers   Deloitte,

---

What are differences between Informatica 7.1 and 6.1

3 Answers  

---

How do you manage the Parameter files while migrating your data from one environment to another environment?

0 Answers  

---

can we use cartesian join in informatica

3 Answers   IBM,

---

What is the sequence generator transformation in informatica?

0 Answers  

---

what is the predefined port in dynamic lookup

2 Answers  

---

Hi All, i have question regarding Change Data Capture in Informatica. As i know we can do this using Incremental Aggregation(i never worked on Informatica but i read) and i think we can do the same with SQL Over write and with variables. Can someone tell me how do we do this using other two techniques.. using SQL Over write and variables. Thanks for the help and greatly appreciated.

1 Answers  

---

What are the static cache and dynamic cache in informatica?

0 Answers  

---

what is the significance of newlookup port in dynamic look up

1 Answers   IBM,

---