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 9451Select * 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 7874Post New Principal Finance Data Warehouse General Interview Questions
Is it possible for upgrade from flex builder 3 standard edition to flex builder 3 professional edition?
Explain the difference between AutoPostBack and IspostBack in ASP.NET?
What is the difference between contracts and scheduling agreements?
What are the different platforms where we can host wcf service ?
How can we identify the resources for which the sessions are waiting?
What is SAP HANA sidecar?
What is detailed category?
Why do we need mongoose?
How they LT panel busbar size choose
What do you understand by a search engine?
What is amdp (abap managed data procedures)?
What is difference between the "throw" and "throw ex" in .net?
What is a left join?
What is the extension of ms word 2013?
How automated assistant work?