Answer / raghavendra reddy

yes,using metadata reporter

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,

---

Hi, If any hav Informatica n DWH FAQ's,Plz do fwd to vanibv6@gmail.com Thnx Vani

1 Answers  

---

What is the difference between a table and the materialized view?

2 Answers  

---

What is data transformation manager process?

0 Answers  

---

Hi, Steps for upgrading from informatica 7x to 9x or the link which will help me to upgrade from informatica 7 to 9. Regards, Eva

1 Answers   Accenture,

---

Can you access a repository created in previous version of Informatica?

1 Answers  

---

What do you understand by a term domain?

0 Answers  

---

what is the location of parameter file in informatica?

1 Answers   TCS,

---

Label in Informatica. How to remove existing Label.

1 Answers   IBM, Infosys,

---

why we use stored procedure transformation?

4 Answers   IBM,

---

for ex: in source 10 records are there with column sal. use a filter transformation condition as Sal=TRUE and connect to target. what will happen.

11 Answers   Accenture,

---

How can we delete duplicate rows from flat files?

0 Answers  

---