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 Interview Questions
What is laravel api?
What are the dialog boxes that are supported in android?
Match the ejb functions given below with the functionality equivalent in sql?
What is the fact table?
What is persistence layer?
Is it better to bitshift a value than to multiply by 2?
Which is india’s first surface to surface missile “ prithvi ” launched?
What are some career opportunities for entertainment managers in the field of Music Management?
Where are c variables stored in memory?
Do we need to have the hana live installed for these reports?
Mention the architecture of django architecture?
How to use a sql function or perform calculations in a statement generating with zend_db_select?
What ports does Cassandra use?
Is id mandatory in hibernate?
Tell us how can you define departmental accounting?