Answer / venkateshmalneni

A fact table is multiple of combination of dimension tables

ie if we want 2 find the fact table size of 3years of
historical date with 200 products and 200 stores

3*365*200*200=fact table size

What is the function of aggregator transformation?

0 Answers  

---

how will u load the data to diminision tables and fact tables,what is the hiraraichy why we are using hirarichy

2 Answers   TCS,

---

What is meant by target load plan?

0 Answers  

---

why normalizer transformation can not used in mapplet? plzzzz answer

2 Answers   Syntel,

---

I HAVE A SOURCE FILE CONTAINING 1|A,1|B,1|C,1|D,2|A,2|B,3|A,3|B AND IN TARGET I SHOULD GET LIKE 1|A+B+C+D 2|A+B 3|A+B WHICH TRANSFORMATION I SHOULD USE

5 Answers   Informatica,

---

What can we do to improve the performance of informatica aggregator transformation?

0 Answers  

---

plz plz plz send client names and project names in informatica?

1 Answers  

---

When do you use mapping parameters? (In which transformations)

1 Answers  

---

What is a design?

1 Answers  

---

if we have a delimiters at unwanted places in a flat file how can we over come those.

0 Answers  

---

If i have one source having 10 ports.In a mapping i use that source one target having that ten ports.Data from 5 ports are going to target through a mapplet and another 5 ports are going to target through another mapplet.Both 2 mapplets are intially passive in nature.But presently my requirment to convert on mapplet to ACtive.How can i do it.

3 Answers   TCS,

---

How can you recover the session in sequential batches?

1 Answers  

---