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 9109Select * 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 7726Post New Principal Finance Data Warehouse General Interview Questions
What is gray box testing?
Explain about house keeping in assembler?
What is ObjectInspector functionality in Hive?
which sanity testing is performed?
Explain Function Pointer?
What is the copy-and-swap idiom?
Give few examples of datareader that is used in different dataproviders.
What are all present producing cost of Per KWH of various Fuel?
What is meant by saying at what current is transistor biased?
Is null a binary search tree?
What is jlayeredpane java?
When performing sanity test on the mobile application what all criteria should be taken into consideration?
What atom 1.0 files look like?
How do I change the default settings in word 2007?
What is pip command in python?