What are aggregate fact tables ? why they are needed? give
an example
Answer Posted / omprakash
It is used to improve the performance of sql query
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
Explain vldb?
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 definition of normalized and denormalized view and what are the differences between them?
Explain what type of indexing mechanism do we need to use for a typical datawarehouse?
Explain can report net connect multiple datasource at a time in report creation time?
What is a source qualifier?
What is MODEL is Data mining world?
How can we run the graph? What is the procedure for that?
Start a batches with in a batch?
What are the advantages and disadvantages of using stored procedures versus calling sql inline in cold fusion?
How many different schemas or dw models can be used in siebel analytics. I know only star and snow flake and any other model that can be used?
What is recovering sessions?
What is execution plan?
How to get the first 100 rows from the flat file into the target?
Explain the advantages of raid 1, 1/0, and 5. What type of raid setup would you put your tx logs.