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

,if we have single SQ in flow and we have router in which it has two group and we want to join these two groups with joiner ?is it possible?

3 Answers   Emphasis,

---

How do you remove duplicate records in informatica?

1 Answers  

---

what is inline view?

1 Answers   IBM,

---

how to use incremental load?

2 Answers   TCS,

---

What are the session parameters?

3 Answers  

---

i have thousand records in my source(flat file) i wanna load 990 records i don't want load first 5 records and last 5 records at informatica level?

3 Answers   Satyam,

---

without using rank transformation how can we rank items by using some other transformations

2 Answers  

---

What happens to map if we alter the datatypes between source and its corresponding source qualifier?

0 Answers  

---

how to get the only updated records in the target

2 Answers  

---

What are the types of caches in lookup?

0 Answers  

---

what is mean by complex business rule ?

0 Answers   Cap Gemini,

---

Explain lookup transformation is active in informatica

0 Answers   Informatica,

---