Explain about core dimension, balanced dimension, and dirty dimension?
No Answer is Posted For this Question
Be the First to Post Answer
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 Bulk Insert?
What is the difference between mapping parameter & mapping variable in data warehousing?
What are the various tools? Explain name a few?
How to know the time taken for particular report execution?
What are modeling tools available in the market?
what are confirmed dimension? We alwys give date as a conformed dimension but if it has different format for different contries say YYMMDD for italy and MM-DD-YYYY for france.Then are they not confirmed.
4 Answers IBM, MAHINDRA, Tech Mahindra,
Why null values are mapped as 0 in fact tables?
What is recovering sessions?
Explain what is the difference between power center & power mart?
Compare aggregates and data marts
Explain what is real time data-warehousing?