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 9313Select * 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 7806Post New Principal Finance Data Warehouse General Interview Questions
How does overpopulation effect ecological balance?
How to demonstrate the use of a variable?
How do I minimize the downtime while i’m updating the applications?
Write about the members that a derived class can add?
What kind of preventive maintenance are there for transformer?
What is the most powerful capabilities of the modelbinder ?
How to size the cooling tower sump / basin for any given circulation rate? What is the guideline?
What's the purpose of using break in each case of switch statement?
How to keep files in HDFS?
What is Instantaneous Earth fault relay,how will work
How do you introduce yourself?
What is a blog roll?
What do you mean by query optimization?
What are the job parameters?
What is go?