Universe Design - one big one or several subject specific universes?
We are scoping out our BO universe design for an SFA/CRM solution.
Source data is Siebel CRM, combined with Sales data from third parties. Limited other data beyond that.
Should we build one big universe with all the subject areas in, or should be build several smaller universes, and ensure we can report across universes (Synchronisation?)
Also, does any one have experience of the siebel rapid marts?
Seems like a one universe solution to me. Let me ask you couple of more questions before giving you the final answer.
1. When you said two sources, are these sources brought to one (target)data warehouse/database?
2- Is this a dimensional model or a relational schema?