what is the difference between aggregate table and fact
table ? how do you load these two tables ?
- 12 Answers
- 49740 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
Can you describe me a problem you faced when you were trying to load data from R3 system and another system outside sap systems?
In document how to create metrics?
After we create a scd table, can we use that particular dimension as a dimension table for star schema?
How we are using this function?
Explain what are the advantages data mining over traditional approaches?
Explain how many ways you create ports?
How can you communicate with web server (apache or iis) from coldfusion?
Hi, If any hav Informatica n DWH FAQ's,Plz do fwd to s.rajanikanth1980@gmail.com Thnx Vani
What is an er diagram?
Explain what is ods (operation data source)?
Why we use repository connectivity?
Explain what is real time data-warehousing?
What is partitioning? What are the types of partitioning?
What is a view as it relates to system modeling?
How to handle multi value dimensions?
