Store (and count) non-fact records?
No Answer is Posted For this Question
Be the First to Post Answer
What is dimensional modelling?
What is the use of tabular model, tabular sql, tabular reference in real time application?
Explain how many ways you create ports?
How can we do ETL process in SQL Server?
What is the difference between Oracle Express and Oracle Discoverer?
What is a data warehousing?
What is meant by metadata in context of a data warehouse and how it is important?
What is the data type of the surrogate key?
What is data type of the surrogate key?
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 hybrid slowly changing dimension?
Explain what is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?