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 9155Select * 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 7746Post New Principal Finance Data Warehouse General Interview Questions
Should you use an orm?
How can you run rails without creating databases?
Write a program to implement OOPS concepts such as inheritance, polymorphism, friend function, operator overloading?
Why we need different consensus mechanisms?
Which one is better windows or linux?
How do I edit a shape in word 2007?
what is credit control management. how to do credit control how to evaluate foreign currency
What is a webpage title?
What is RMS migrations?
What is linqpad used for?
How do you override the underlining of hyperlinks?
What is tty in linux process?
i need gate exam civil engineering question papers with answers
What are the key components of a test case template
Explain the difference between a microcontroller and an embedded system?