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 7991Select * 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 7065Post New Principal Finance Interview Questions
Explain the concept and use of type void.
why ht motors are star connected?
How will you define org structure in MM?
How to install react js on your local machine?
What is meant by object oriented programming?
A person somehow gets hold of an extraordinary rare bird, keeps it as a pet for two years and then sells it off. Will related profit be taxable as capital gain?
What is the use of RSTART, RLENGTH and match ?
Tell me what is serialization?
What is the significance of factoring in cryptography?
How do you document abap/4 programs? Do you use program documentation menu option?
In vpc with private and public subnets, database servers should ideally be launched into which subnet?
What is data analysis? Where it will be used?
Explain about gui scripting?
How much is the tax & surcharge % against d-1 form. on cement,steel,electrical item,RMC,
Is webflow better than wordpress?
