What is a linked cube?
Why should we use data ware housing and how can you extract data for analysis with example?
Can any one explain the hierarchies level data warehousing.
suppose data are coming from different locations and those data will not change . is there any need to use surrogate key ?
Explain what are the different methods of loading dimension tables?
What is Operational Data Store?
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 me what are data marts?
What is an OLAP (On-line Analytical processing) system?
What is surrogate key? Where we use it? Explain with examples.
What is the difference between star and snowflake schemas?
How can we run the graph?
What are the difference between snow flake and star schema? What are situations where snow flake schema is better than star schema to use and when the oppositeis true?