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
- 53632 Views
- Target, I also Faced
- E-Mail Answers
Answer Posted / jayalakshmi
fact table is one which contains all the facts
(measures).aggregate table is one which is created after
the cube is processed.this aggregate table contains human
unreadable text.
| Is This Answer Correct ? | 14 Yes | 50 No |
Post New Answer View All Answers
i have scheduled a report in a job in the cognos8.3 which would send the reports to the respective user ,now the repot ran and is sent to the respective user but it contains some unwanted data. So based on the senario can any one tell me that can we recall back the report ??????
How to calculate fact table granularity?
How many clustered indexes can you create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id 347 what is hybrid slowly changing dimension?
Suppose we want to display zero when null values coming to report how can we do that?
Hi, i want to do certification in datawarehouse?? which certification is best in current trend?? pls mention the cost also if u can....
what type of raid setup would you put your tx logs?
explain about balanced dimension,
What is the difference between snowflake and star schema? What are situations where snowflake schema is better than star schema when the opposite is true?
Explain can report net connect multiple datasource at a time in report creation time?
What is the function of etl when used in data warehousing?
Explain the difference between data ware house & data mart?
Explain a mapping, session, worklet, workflow, mapplet?
What is Operational Data Store?
What is pre-emptive and non-pre-emptive?
Explain the advantages of raid 1, 1/0, and 5. What type of raid setup would you put your tx logs.
