Explain difference between data ware house & data mart?
No Answer is Posted For this Question
Be the First to Post Answer
How to performance tune reports?
Where the applications and where
What needs to be done while starting the database?
Explain the definition of normalized and denormalized view and what are the differences between them?
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,
What is factless fact tables?
How can Oracle Materialized Views be used to speed up data warehouse queries?
What is analytical or analytic mean?
How to calculate fact table granularity?
What is "method/1"?
Do you view contain data?
What is Analysis Services?