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 9186Select * 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 7753Post New Principal Finance Interview Questions
How to control page titles in jquery mobile? : jquery mobile
What is locale?
How long do you plan on staying with us
Define the Internet of Things (IoT) Function in Azure Cloud Service?
What are the advantages of using a ball mill over other conventional methods of crushing?
For what purpose ammonal is used?
Which module is required to have redirection possible?
Why ide is recommended for use while programming with php?
How to Put an Existing Model under Version Control?
I need a help with a program: Write a C program that uses data input in determining the whole of points A and a whole of circles B. Find two points in A so that the line which passes through them, cut through the maximum number of circles.
Q.what type of issues you are getting and tell me some issues in asset acctng,fi-mm,co?
How many types of cookies are there in asp.net?
What is diff between EVAL & MOVE?
What is the real mean of dhcp?
What is an algorithm in java collection framework? : java collections