Is there a rule concerning aggregates tables mirroring the fact tables? Will most OLAP tools be able to handle the situation when summary facts are different than fact tables?
Chuck Kelley’s Answer: I am not sure exactly what you mean by mirroring the fact table. Aggregate (or summary) tables have a different granularity of data and different dimensions, and mirroring is about duplicating the data. Now, if you asking if the numbers should add up, then I would say "Most definitely."
Register or login for access to this item and much more
All Information Management content is archived after seven days.
Community members receive:
- All recent and archived articles
- Conference offers and updates
- A full menu of enewsletter options
- Web seminars, white papers, ebooks
Already have an account? Log In
Don't have an account? Register for Free Unlimited Access