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
- 3609 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
What the various ways to tune a teradata query
hai if any one having any project sample table structure please froward to my mail id tauseefwst@yahoo.com
what is ad-hoc access? what is the diff b/w managed query and ad-hoc access?
how can we view column head in first page but not in remaining pages?
What is global database name?
What is the difference between oracle and MS Access?
What is the advantage of varchar2 over char?
What are different types of blocks used in stored procedure?
What is a trace file?
What is the difference between a stored procedure and a query?
What advantages does DBMS have over traditional file systems?
Which Statement would you use to remove the EMPLOYEE_Id_PK PRIMARY KEY constraint and all depending constraints from the EMPLOYEE table?
First input columns brand, mt, re values are ov, 1,re vg, 2,re wu ,3,re. Second input columns are brand, mt, cx their records are ov,4,vg ,5,cx Wu, 6,cx and third input columns brand, mt, rt values are ov,7,rt vg, 8,rt wu, 9,rt but my output is brand, re, cx,rt values are ov, 1,4,7 vg, 2,5,8 wu, 3,6,9
How do I manually create a database?
What is dialect in database?
