Explain why dimenstion tables are denormalized in nature?
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.
Difference between ODS and Staging
Hi, Could any one tell me which schema (star and snow flake schema) will take much space? Thanks S.A.K
6 Answers Accenture, IBM, TCS,
Which are the olap tools available that are supported by oracle?
What is Time Series algorithm in data mining?
Name a few sectors which use data warehousing?
How to add a number to a macro variable?
In my report contain product name, amount, country, sales person I want to create one prompt: sales territory.( Ex: asia, us, uk, aus), but territory column is not there in my model and source if u select the asia in prompt page-ll asian country results I want in report page I discussed with my friends and colleague, they told use the static choice function still I face this problem. If u know please tell me?
If your client approaches you and says that he wants to create a Datawarehouse, and provides just the info regarding his source systems. What are all the neccessary actions one is supposed to take/understand and get back with a comprehensive document which convinces the client to proceed with the DW initiative. What are all the documents we need to provide the client?
Explain what are the tasks that loadmanger process will do?
What is the difference between data warehouse and operational systems?
What is the difference between OLAP, ROLAP, MOLAP and HOLAP?