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!
Sid Adelman's Answer: It would be worth exploring incremental loads. Most of the extract/transform/load (ETL) tools have this capability.
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