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 a filter transformation and why it is an active one?

0 Answers  

---

how lookup is acting as both active and passive ? how is it possitble?

9 Answers   TCS,

---

What is Index Caches size?

0 Answers   Informatica,

---

guys which is the best institute in banglore to learn informatica??

2 Answers  

---

Hi Friends, I want lo truncate my records from target before loading current month data,but i dont have permission to truncate with truncate option if u know any other way please give your valuable input for this. Thanks Abhishek

5 Answers   CSC,

---

what is the look up transformation?

2 Answers   Informatica,

---

I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.

0 Answers  

---

Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?

0 Answers  

---

what are challenges that you faced in testing? give solution to it?

1 Answers  

---

Are there any types of Dynamic Caches in informatica

4 Answers   Accenture,

---

Design a mapping to get year of join for each employee.

4 Answers   Accenture,

---

What are the different types of repositories created using informatica?

0 Answers  

---