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,

---

Explain the code page compatibility?

0 Answers  

---

What is the meaning of up gradation of repository?

0 Answers  

---

What is an MDDB? What is the difference between MDDBs and RDBMSs?

3 Answers  

---

How do you avoid duplicate records with out using source qualifier,expression,aggrigator,sorter and lookup transformations ?

4 Answers   IBM,

---

Define mapping and session?

0 Answers   Informatica,

---

what is the Default Source Option For Update Strategy Transformation?

0 Answers   Informatica,

---

Explian the Process of deployment groups in informatica

0 Answers   Informatica,

---

What is the difference between Bitmap and Btree index?

3 Answers   Mind Tree,

---

what are the different types of transformation available in informatica. And what are the mostly used ones among them?

0 Answers  

---

While importing the relational source defintion from database,what are the meta data of source U import?

1 Answers  

---

Generally how many Fact Tables and Dimensions Table you have used in the Project? Which one is loaded first Fact Table or Dimensions Table into the warehouse? What is the size of the Fact Table and Dimension Table? what is the size of the table and warehouse

5 Answers   TCS,

---