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 8005Select * 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 7071Post New Principal Finance Interview Questions
What technology is used to avoid interference in bluetooth?
Explain the field values for tools tables?
What is cohort type?
Tell me about virtual memory?
What is the use of string function sub(regex,replacement,string)?
What is the difference between lc and bg(letter of credit
Explain the Important tcodes in ALE Idocs?
List some advantages and disadvantages of manual testing.
as started in the job offer notification, is our basic salary of 1lakh good for you if employed?
What is ## preprocessor operator in c?
what should be the no load current for 3 phase ac motors ranging from 5 kw to 1000kw?
what are the key job responsbilites of area mamager in pharma
why diodes are not operated in the breakdown region in rectifiers?
What is the purpose of the finally clause of a try-catch-finally statement in java programming?
Why do you think you qualify for a human resource executive's/manager' position?