Question: We need a justification for having a DW? Is it possible to have transactional databases replicated as a DW, provided the data is clean and similar to the DW structure? What are the pros and cons of this approach?
Adrienne Tannenbaum's Answer: What you are describing is known as a data mart. These are often the best way to go for a few reasons:
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