What is is the guidelines to build universe with better performance? R performance tuning issues of universes?
No Answer is Posted For this Question
Be the First to Post Answer
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.
Explain the difference between filter and conditin?
Explain what is a cube in data warehousing concept?
Explain what is the metadata extension?
Explain about core dimension, balanced dimension, and dirty dimension?
Explain are data mart and dwh normalized or denormalized? Do both of them exist in
Explain the hierarchies level data warehousing.
What are the stages of datawarehousing?
Advantages of de normalized data?
What Oracle tools can be used to design and build a W/H?
explain the ROLLUP, CUBE, RANK AND DENSE_RANK FUNCTIONS OF ORACLE 8I
3 Answers IBM, Ness Technologies,
What are the approaches used by optimizer during execution plan?