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 9313Select * 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 7806Post New Principal Finance Interview Questions
What do you know about artificial intelligence? Give an example where ai is used in our regular lives?
If I have a char * variable pointing to the name of a function ..
Expand-------SCAN
What is a memo field?
What are the key features in sap warehouse management?
How does search engine perform? - SEO
What does indexof return in java?
What is the formula for if in excel?
Digital marketing is better than traditional marketing, can you please explain the statement?
What is port 135 commonly used for?
What is the difference between translate and replace in oracle?
Differentiate between supervised and unsupervised learning?
How do you stop an access query?
How describe our city(banglore) in a topic round during the interview time?
What is overloading and overriding in java?