What Oracle features can be used to optimize my Warehouse
system?
Answer / abhishek soni
Partition table,bitmap index,sequence,table function,sql
loader ,function like cube,roll_up etc.
Is This Answer Correct ? | 1 Yes | 0 No |
Explain about core dimension,
What is partitioning? What are the types of partitioning?
What is difference between model & package?
How to generate iqd file from framework manager?
What is the difference between datawarehouse and bi?
Explain what are the modules in power mart?
Is there any default username & pwd for bo designer & supervisor?
Briefly state different between data ware house & data mart?
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,
What is data type of the surrogate key?
Why should we use data ware housing and how can you extract data for analysis with example?
does anyone "QlikView" BI tool. if you have any docs send me pls. yaparas84@gmail.com