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 8015Select * 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 7075Post 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)
When do you call copy constructor?
What are the methods associated with the factorybean interface?
Change the url for a hyperlink using jquery?
Explain percentage approved.
What is tomcat 8?
How can you switch back from a frame?
What is pointcut in spring?
What is datalist tag?
In what way the validity fault handler concludes?
tell me about a time you were able to successfully deal with another person even when that individual may not have personally liked you or vice versa.
Discuss about changing dataset name in proc.
What is Workgroup, Worklist and Workbasket?
How to implement a multithreaded applet?
Can anybody give some examples of tickets in om, pa.? What are the tickets you will get in support project please provide me with solution?
What are the uses of function keys?
