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 8013Select * 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 Interview Questions
How will you print number in reverse (descending) order in BST.
"A dimension table is wide but the fact table is deep," explain the statement in your own words.
What applications use python?
What are the various types of shared variable in apache spark?
What is cas?
What is deserialization?
What is the role of a web server?
what are the different Dataset event handlers?
How can we remove handlers at run time?
How do you do performance tuning of wls?
Give some situations where you will use an SVM over a RandomForest Machine Learning algorithm and vice-versa?
In inductive logic programming what needed to be satisfied?
How is the strength of cement measured?
Justify services user can’t use to deploy an app?
Can we perform LINQ on XML?
