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
- 53586 Views
- Target, I also Faced
- E-Mail Answers
Answer Posted / ajit dada pawar
fact table is one which contains all the facts
.aggregate table is one which is created after
the cube is processed.this aggregate table contains human
unreadable text.
| Is This Answer Correct ? | 1 Yes | 10 No |
Post New Answer View All Answers
Suppose date is 05sep2005; I want the output like 05sep2005:00:00:00 ; how it will come?
Suppose you are filtering the rows using a filter transformation only the rows meet the condition pass to the target. Tell me where the rows will go that does not meetthe condition.
Explain a linked cube?
What is is the guidelines to build universe with better performance? R performance tuning issues of universes?
In microstrategy, how can we direct the sql generated to use a specifc table?
What is cubes?
How to improve session performance in aggregator transformation?
What are the advantages and disadvantages of using stored procedures versus calling sql inline in cold fusion?
Database in use is oracle?
What is the main difference between inmon and kimball philosophies of data warehousing?
What are components of report studio?
What is Sequence clustering algorithm?
Code the tables statement for a single-level (most common) frequency?
Explain how to generate iqd file from framework manager?
What is bi?
