Explain what is the difference between datawarehouse and bi?
No Answer is Posted For this Question
Be the First to Post Answer
What are the different types of segments?
What are cluster analysis in data warehousing?
Explain in simple terms, the concept of Data Mining.
Explain what is metadata reporter?
How to know the time taken for particular report execution?
Is there any rownum object from which we can do this?
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 what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?
Explain what is fact less fact table? Where you have used it in your project?
What are the other names given to data warehousing?
Explain techniques of error handling - ignore , rejecting bad records to a flat file , loading the records and reviewing them (default values)?
In a star schema, are foreign key constraints between facts and dimensions neccessary?