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

Plz can anybody send Informatica and Cognos FAQ Plz To thid ID ppradeep_dwh@ayhoo.co.in

2 Answers  

---

Explain the difference between mapping parameter and mapping variable?

0 Answers  

---

what is the Default Source Option For Update Strategy Transformation?

0 Answers   Informatica,

---

i have a wf i want to run this very day 3 time every 3 hours how can you scheduled that?

1 Answers   Mind Tree,

---

Generally how many Fact Tables and Dimensions Table you have used in the Project? Which one is loaded first Fact Table or Dimensions Table into the warehouse? What is the size of the Fact Table and Dimension Table? what is the size of the table and warehouse

5 Answers   TCS,

---

how do u fnd the duplicate rows and how to delete the duplicate rows?

2 Answers   IBM,

---

Can you generate sequence numbers without using the sequence generator transformation?

0 Answers  

---

Plz..let me know differences between Informatica 7.1 and 8.1?

3 Answers  

---

How do we eliminate duplicate records in a flat file without using Sorter and Aggregator?

7 Answers   iNautix,

---

I have a source either file or db table Eno ename sal dept 101 sri 100 1 102 seeta 200 2 103 lax 300 3 104 ravam 76 1 105 soorp 120 2 Want to run a session 3 times. First time: it should populate dept 1 Second time: dept 2 only Third time: dept 3 only How can we do this?

2 Answers   TCS,

---

What is lookup transformation?

0 Answers  

---

what are presession,postsession success and postsession failure commands ?

1 Answers  

---