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 8021Select * 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 7083Post New Principal Finance Interview Questions
What is the difference between spiders, robots and crawlers?
List the three steps for creating an object for a class?
Does go (golang) support operator overloading?
What is span in HTML?
can you show me the test cases on registration form
Explain the purpose of oracle real application clusters (rac)?
What is a uniformly distributed load?
How are object properties assigned?
What is object in java?
What is build process?
What are sql commands?
What is the relation between fun and work? What do you think is most important for growth of company?
How do I split a cell in excel?
Which are the three modes in which hadoop can be run?
How to viewing the angular 4 apps in a browser using ionic 3 cli?