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
what are different storage options supported by oracle ?
Is framework manager an un-needed overhead? As we know report studio allows us to create the data model from a query and thereby skipping framework manager. Given that this feature is available, in what scenarios would one want to skip framework manager?
What is scd1 , scd2 , scd3?
How do you create surrogate key using ab initio?
Explain the data types present in bo n wht happens if we implement view in the designer n report?
What is partitioning? What are the types of partitioning?
What are the different methods of loading dimension tables?
Explain what are the advantages and disadvantages of reporting directly against the database?
what are the other factors of the database on which the loading performance depend?
Explain degenerate dimension table?
What are the different problems that ?Data mining? can solve?
How to create diff. Types of templates?
what are the all possible features supported modify stage?
In general, how many Fact & Dimension tables are present in a Banking Data warehouse project ?
What is informatica architecture?