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
- 53050 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
Suppose date is 05sep2005; I want the output like 05sep2005:00:00:00 ; how it will come?
What is Sequence clustering algorithm?
What is is a star schema?
What is scd1 , scd2 , scd3?
What are the data types present in bo?
What is static and local variable?
Can any one explain the hierarchies level data warehousing.
Can we have multiple application.cfm file in an application?
Explain multivalued dependency?
Suppose a null dataset with 10 variables; I want to print only name of the varibales in log window and also output window. How can we do this one?
Explain what is a staging area? Do we need it? What is the purpose of a staging area?
Explain can report net connect multiple datasource at a time in report creation time?
Explain if a flat file cotains 1000 records how can I get first and last records only?
What are situations where snow flake schema is better than star schema to use and when the opposite is true?
What is many-to-many dimensional model in datawarehousing ?
