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 9154Select * 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 Interview Questions
What is iqueryable?
How can I insert a tab in a table cell?
What is assembly version series sequence?
how to join two table using query expression?
How do I find a string in excel?
What is windows azure?
What makes a sales person good?
What is the symbol for line break?
What is the use of azure active directory?
What is the difference between snowflake and star schema? What are situations where snowflake schema is better than star schema when the opposite is true?
What are the three classes of errors that can occur in php?
What is htmlentities?
What are loops in java?
Will there be a windows server 2016 r2?
How to change the batch job to interactive job?