If I have table T1 and table T2 T1 has 250 cols and 10,000 rows T2 has 2 billion rows and 10 cols Which one would be Fact table and which one would be Dimension table and why ?

3 Answers   Extech, Principal Finance,

---

2.What is staging area ?

4 Answers   HCL, IBM, iFlex, TCS,

---

Suppose you are filtering the rows using a filter transformation only the rows meet the condition pass to the target. Tell me where the rows will go that does not meetthe condition.

0 Answers  

---

Explain which columns go to the fact table and which columns go the dimension table?

0 Answers  

---

What are different stages of ?Data mining??

1 Answers  

---

---

in siebel analytics by using dashboard prompts in a page have 2 reports so i have to give dashboard prompt to applied on first report only that will not applied to 2 report how it will do

1 Answers   IBM,

---

Compare and contrast aggregates & indexes

0 Answers   IBM, TCS,

---

What is difference between a connected look up and unconnected look up?

1 Answers  

---

Explain how many ways you create ports?

0 Answers  

---

how to find unique records in informatica level

1 Answers   IBM,

---

which automation tool is used in data warehouse testing?

1 Answers  

---

How can we schedule the graph in unix?

0 Answers  

---