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 connected transformation?

0 Answers   Informatica,

---

what are the real time problems generally come up while doing or running mapping or any transformation?

2 Answers  

---

disable caching in a lookup transformation?

1 Answers  

---

My source has 100 records. I have targets say in number 5. all target tables has parent and child relationships in between themselves. Now I want to load all 100 records into all targets. How U can ensure that record inserted in parent and then loaded into child.

3 Answers   Cognizant,

---

My source data like... Empid Name 10 chandra 10 sekhar I am expecting result is Empid Ename 10 Chandrasekhar How can we solve this prob?

3 Answers   Cap Gemini,

---

What is the fact table?

0 Answers  

---

What are active and passive transformations?

0 Answers   Informatica,

---

hw to load this give the mapping? cty state o/p c1 s1 c1 c1 s2 s1 c1 s1 c1 c2 s3 s2 c3 s4 c1 c3 s2 s1 c2 s3 c3 s4 c3 s2 2 columns should be loaded to one column in target table?

1 Answers   Wipro,

---

i want excute multiple sessions in one workflow using the "start task".what do i need to do?

2 Answers  

---

What is an Integration service in Informatica?

0 Answers  

---

i have ten flat files with same structure,if i want to load it to single target,and mapping needs to should show only one source.what will be the steps to taken to achieve it?/

5 Answers   L&T,

---

how i will stop my workflow after 10 errors

2 Answers   HP,

---