Link to home
Start Free TrialLog in
Avatar of rhservan
rhservanFlag for United States of America

asked on

How do I transition to a Data Warehouse or mart?

Currently - I have a Transactional database updated daily with ETL. This infromation is used by a cube.

Desired - Multidimensional database with a cube.

Do I maintain the Transactional database and populate the Multidimensional database with the Transactional database?  Or, would I remove the transactional database and move the ETL over to just populate multidimensional database directly?
Avatar of rhservan
Flag of United States of America image


Hello anybody out there?
Avatar of oleggold
Flag of United States of America image

Link to home
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
If Your data quantity is VLDB then DWH with highly ummarized facts is better,when on other hand Your data needs to be constantly updated and then viewed multidimensionaly once a while the currend model is probably th best OLTP + CUBE
data will need to be updated constantly and viewed as needed & with notifications prompting for users to view.  

Also,  can your relay with terminolgy for scenario.