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
- 53999 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
Explain why fact table is in normal form?
Explain the data type of the surrogate key?
Where the data cube technology is used?
What is data stream and data adaopter. Is it same are different? Explain?
How to create prompts in report net?
How do you define data block size?
Explain piconet?
Explain reference cursor?
What is the difference between Datawarehouse and OLAP?
What are vaious etl tools in the market?
Explain a mapping, session, worklet, workflow, mapplet?
Where the cache files stored?
What is informatica architecture?
Explain how to export mappings to the production environment?
What is the purpose of cluster analysis in data warehousing?
