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 9308Select * 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 7805Post New Principal Finance Interview Questions
How do I delete multiple items in word?
What is meant by method chaining?
Can I download linux for free?
In an html form I have a button which makes us to open another page in 15 seconds. How will do you that?
Why do we need a server?
What is biztalk server? : biztalk server
Define role of veracity in big data?
How do we assign page-specific attributes?
How to Obtain a list of available BDE language drivers?
What are the differences between batch gradient descent, stochastic gradient descent, and mini-batch gradient descent?
Define a constructor?
Explain joiner transformation in informatica
differentiate between total moisture and inherent moisture of coal.
What does double quotation mean?
What is the difference between Remove and Delete buttons on solution?