how to create model from two data sources

[inu]

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

[MFGF]

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.