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?
DatabasesMicrosoft DevelopmentMicrosoft SQL Server 2008