Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between aggregate table and fact
table ? how do you load these two tables ?
- 12 Answers
- 53078 Views
- Target, I also Faced
- E-Mail Answers
Answer Posted / tadikonda
Diff b/w two tables is performance.
Fact tables contains million of records and retriving the
records from fact table takes time.where as aggregate table
contains limited data from all the required tables,and we
retrive the data it takes less time.
| Is This Answer Correct ? | 46 Yes | 10 No |
Post New Answer View All Answers
What is the difference between mapping parameter & mapping variable in data warehousing?
What is fact less fact table? Where you have used it in your project?
what is an use case?
How to limit the max no of rows retrieved in the report?
What is the extension of file to save template?
What is data cleaning? How can we do that?
Explain what are the advantages and disadvantages of reporting directly against the database?
Explain normalization?
What are modeling tools available in the market?
Code the tables statement for a single-level (most common) frequency?
Explain what are the various file formats involved in reportnet?
What are the different types of join operations?
What is latest version of power center / power mart?
What are the different methods of loading dimension tables?
Explain how to get the first 100 rows from the flat file into the target?
