Hi all,
I am having 4 datasources, each is coming from
1. CRM
2. ILLINOS
3.Transactional Inbuitl system
4.Inbuilt system.
Each of having ms sql server as a datasource.
What is the best practices?
Should we go for datawarehouse and then connect using framework manager.
OR
Directly using framework manager.
Is it possible to map the data from 4 different data sources.
your guidance is appreciated.
Thanks in advance.
If the facts in these system are at different granularity and if the number of conformed diemnsions are very low, it might be a good idea to go for a DWH. (Denormalized data that can be represented as a star schema).
It is also possible to join them in FM as long as you have clarity on the metadata in each system and how to connect them. But in terms of query generation, performance and troubleshooting to achieve the required results couldd be challenging.
Infact, have a look at this post from IBM Cognos:
http://www.ibm.com/developerworks/data/library/cognos/modeling/design/page557.html
Hi,
Thank you for your reply.
I'll go through the docs and then let you'll know.
Appreciated
Thanks