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 9316Select * 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 7807Post New Principal Finance Data Warehouse General Interview Questions
How do I get the | symbol on my keyboard?
How many types of relationships are there in ms access?
The transaction should not be displayed in User Easy access menu. How to do user auditing in sap? What will u audit?
What is the dom browser extension?
What is mixins in css?
Explain the features of interfaces in java?
Do you know what is adobe photoshop elements 13?
Does imap delete emails from server?
How do I show all tabs in excel?
why electronic instruments is more favorable than electrical?
if you delete a record from UI, what happens in the database. can you bring the record back?
What is orm in python django?
When we are using token in blue prism?
What do you mean by constructor?
Tell me about a time when you missed an obvious solution to a problem?