Explain the main differences between star and snowflake schema?
What is data validation strategies for data mart v?
Explain what is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?
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 Snow Flake Schema design in database?
What is data cleaning? How can we do that?
What is your spectra photometer working principles?
How to provide security in frame work manager for a query subject?
What is Grain & Granularity in Data Warehouse.
what are the similarities between ROLAP and MOLAP
Explain datawarehousing?
Where the cache files stored?
Which is the optimized method of extracting the data.