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 7962Select * 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 7050Post New Principal Finance Data Warehouse General Interview Questions
- Principal Finance COBOL Interview Questions (1)
- Principal Finance JCL Interview Questions (1)
- Principal Finance Informatica Interview Questions (1) Principal Finance Data Warehouse General Interview Questions (3)
What is syntax?
what r the steps in operation management
What does rundll32 exe do?
Does the internet of everything talk about cisco based or ibm based architecture?
What is default export in typescript?
due date for issue of C form, if c form is not issue what will be the consequences
Calculate debtors at the end of the year? debtors-50000, bad debts-2000, discount allowed-1000, 5% on bad debt, 2% discount allowed?
What is the bond angle of phosphorous?
How to do left join in linq with entity framework?
sample & previous year papers of sta & je (electronics 0
Explain scope of static variables?
Is it possible to download the Siemens Selection Chart(TYPE 2 coordination) for 1) fuseless selection 2)Fuse selection
What do multicast delegates mean?
What is unix operating system used for?
What is cursor with hold option in db2?
