Friday, March 9, 2012

How to create a dimension with attribute comming from Oracle and sql server databases

I have 2 data sources. An oracle database and a sql server database

I would like to create a dimension with attribute comming from oracle and sql server.

Is it possible?

Hello,

I think you're going to be stuck creating a linked server between SQLServer and Oracle. If you can accomplish this, than i don't think you'll have any problems.

C

No comments:

Post a Comment