Interested to Buy Any Domain ? << Click Here >> for more details...
Does aggregate and fact tables gets populated from
transactional data with only diffrence in there granularity?
Please clarify?
- 1 Answers
- 3485 Views
- I also Faced
- E-Mail Answers
Answer Posted / pratap
Th Aggregate tables will always have higher granularity than the fact table. The grain of aggregate table can be derived from one key or combination of multiple keys from within the fact table.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How do I setup a database connection?
Explain the record term used in database.
What is the difference between specialization and generalization?
What is the difference between primary key, foreign key and candidate key?
Display the employees whose salary is less than average salary.
What is the DIF format and when we will use in teradata
How many types of normalization? What is the use of it?
How heap is implemented in database?
What is the role of tester in discovery(in Checklist)?
what is data access layer?
What is Data Modelling?
What advantages does DBMS have over traditional file systems?
During insert operation in Netezza Connector, if we give direct option as Yes , is there any issue?
can i use the commands "modify" and Change in DB2 to alter my column datatype and its name in a table?
Explain entity set?
