Most star schema data warehouse technology we have examined uses a batch roll up and consolidation to create the fact table. This is typically done once a month due to the load and roll up time required. Is the technology available to do incremental load (just the new transactions) and population of the fact table? We have a need for daily refresh of the information in the fact table. The processing time of a full load will soon take more hours than are in a day!

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

Don't have an account? Register for Free Unlimited Access