Quote from: inu on 23 Jul 2014 01:01:45 AM
HI
Please guide me in creating model from two data souces step by step. so that i can reach to the desired output. It may be two database say Sql server and Oracle or from the same db.
Thanks
Inam
1. Build your model and import data from your first data source.
2. Run the metadata wizard a second time and import data from your second data source.
3. Add a relationship to join the relevant item that links the data (if applicable)
Best practice guidelines indicate you should import the different data sources into different namespaces to avoid any naming clashes
Cheers!
MF.