Interested to Buy Any Domain ? << Click Here >> for more details...
What are aggregate fact tables ? why they are needed? give
an example
- 2 Answers
- 10705 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / rofali
In aggregate Fact tables data is aggregated at some level.
for example, we have a fact table for sales in which data
gets stored on daily basis. Now we can make another fact
table for sales which holds the sales data, aggregated at
weekly level. Now if we have to do repoting on weekly basis
we can directly use the aggregated fact table.this will be
the more efficient way.
| Is This Answer Correct ? | 18 Yes | 0 No |
Answer / omprakash
It is used to improve the performance of sql query
| Is This Answer Correct ? | 7 Yes | 0 No |
What are fact, dimension, and measure?
Explain what are conformed dimensions?
What is the use of dimensional modeling in data warehousing?
What are the reasons to use a chameleon method in data warehousing?
What are the advantages of raid 1, 1/0, and
Select * from emp,dept,loc where emp.deptno left outer join dept.deptno and dept.locno=loc.locno. No need to consider the syntax but is it possible to have left outer join and equi join in the same SQL like this ? can we have right outer join and left outer join in the same SQL ---
1 Answers Principal Finance, PT Metalogix Infolink Persada,
What is the purpose of Dataware Control?
Can any one explain the hierarchies level data warehousing.
How to allow a dynamic selection of a column for a measure in a chart,without using variable?
What is drilling across?
Explain what are data marts?
How to use the tool Ontobulider
Teradata 
