i have two flat files.. containing same type of data i want to load it to dwh..how many source qualifires i need

7 Answers   Deloitte,

---

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,

---

Why is sorter an active transformation?

0 Answers  

---

After draging the ports of three sources(sql server,oracle,informix) to a single source qualifier, can you map these three ports directly to target?

6 Answers  

---

What is a joiner transformation and why it is an active one?

0 Answers  

---

How does a rank transform differ from aggregator transform functions max and min?

0 Answers  

---

Difference between Data and Index Caches?

0 Answers   Informatica,

---

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

2 Answers  

---

How does the server recognize the source and target databases. Elaborate on this.

1 Answers  

---

What r the type of indexes u generally used in informatica?

2 Answers   Keane India Ltd,

---

What is an incremental loading? in which situations we will use incremental loading

2 Answers   HCL,

---

How to Join Tables my Source is having 15 table target is one?

4 Answers   TCS,

---