Aggregate table columns
2 posters
Page 1 of 1
Aggregate table columns
Suppose if my fact table has 2 columns like cola and colb. And I have an aggregate table with colc and the value of colc is cola*colb from fct.
Is it better to do the calculations in fct and store and then move to aggregate or shall I this transformation while moving to aggregate table rather than storing it in fct table?
Is it better to do the calculations in fct and store and then move to aggregate or shall I this transformation while moving to aggregate table rather than storing it in fct table?
jithindas- Posts : 1
Join date : 2013-02-19
Re: Aggregate table columns
The decision to create an aggregate is a matter of wither it will produce a significant performance enhancement over just using the atomic facts. With that decision made, do the calculation as part of the transformation into the aggregate. There is no need to store the value in the original fact, as there is no technical reason to do so and it would hamper performance of the original fact table by making it larger (assuming the transformation is as simple as you have expressed).
Similar topics
» Aggregate Table Granularity
» Too many columns in fact table
» SK and ID columns in a Fact table
» Employee Hierarchy Dimension Table
» Maintainance columns in dimension table
» Too many columns in fact table
» SK and ID columns in a Fact table
» Employee Hierarchy Dimension Table
» Maintainance columns in dimension table
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum