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,

---

How can we transform row to column?

1 Answers  

---

Select * from emp,dept,loc where emp.deptno left outer join dept.deptno and dept.locno=loc.locno. No need to consider the syntax but is it possible to have left outer join and equi join in the same SQL like this ? can we have right outer join and left outer join in the same SQL ---

1 Answers   Principal Finance, PT Metalogix Infolink Persada,

---

Explain what is the difference between powerplay transformer and power play reports?

0 Answers  

---

Explain how to get the first 100 rows from the flat file into the target?

0 Answers  

---

---

How can we run the graph? What is the procedure for that?

0 Answers  

---

What is MDX?

2 Answers   TCS,

---

What is a cube in data warehousing concept?

0 Answers  

---

Explain about Control M JObs detaily?How to execute this.

2 Answers   Scope International,

---

Tell me what is degree of a relation?

0 Answers  

---

if we increase the number of dimensions will the rows in fact table increase or decrease??

3 Answers   IBM,

---

2.What is staging area ?

4 Answers   HCL, IBM, iFlex, TCS,

---