mayurkb (4/17/2015)
Thank you again and understood.Does everything that apply to data warehouse also apply to datamart? We are not really IT and not making a datamart for my company. We make healthcare software and want to develop and ship a datamart for the suite of products that we develop.
I'm not sure I follow what it means to "ship" a datamart. Perhaps you simply mean that your software package needs a portable database to contain reference data or from which the client will perform analytical reporting.
The design of any database, especially a datamart or data warehouse, should be purpose driven. First determine what the end user needs to get out of it, which then leads to a determination of what needs to go into it, which then leads to a specific conceptual and technical implementation. A datamart could be relational database, an OLAP cube, or even an Excel sheet.
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho