Answer / suraj kedia

Aggregator transformation is used to calculate values in a
group. It is the only t/r which can be used for aggregate
calculations e.g: Sum,avg,max,min,count....

So when we don't need any such aggregate calculations, than
we don't use aggregator transformation.

Answer / vikram

when thre are no group by or any other calculations required

How to generate a single mapping for both the historical and incremental load.

2 Answers   CSC, TATA,

---

What is facttable granularity?

2 Answers  

---

How do you convert single row from source into three rows into target?

0 Answers  

---

Explain direct and indirect flat file loading (source file type) - informatica

0 Answers   Informatica,

---

Which kind of index is preferred in DWH?

2 Answers  

---

---

What are Target Options on the Servers?

1 Answers  

---

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,

---

my source having 10 records but how can i load 20 records in target, i am not bother about duplicates?

10 Answers   Cap Gemini, Wipro,

---

Why use shortcuts(Instead of making copies).

1 Answers  

---

Why update strategy and union transformations are active?

0 Answers  

---

i want to load data in to two targets..one is dimension table and the other is fact table?how can i load ata a time

3 Answers   iGate,

---

How i can Schdule the Informatica job in "Unix Corn Schduling tool" ?

2 Answers  

---