What is the goal of optimizer?
No Answer is Posted For this Question
Be the First to Post Answer
wht is degenerated dimension ?it's uses?
Select * 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 Answers Principal Finance, PT Metalogix Infolink Persada,
Explain the definition of normalized and denormalized view?
explain about balanced dimension,
What is a view as it relates to system modeling?
What is surrogate key? Where we use it?
Compare aggregates and data marts
What is a full backup?
Explain what is data validation strategies for data mart validation after loading process?
Explain what is the difference between power center & power mart?
Explain what are the possible data marts in retail sales?
Explain why fact table is in normal form?