DSXchange

Posted: **Tue Jul 10, 2007 11:07 pm**

hi
Is it possible to access to two different tables from two different databases on two different servers from a single database stage. Both the databases are Oracle 10g databases.

Please reply.

Posted: **Tue Jul 10, 2007 11:25 pm**

Only via the same mechanism you would use outside of DataStage - a dblink.

Posted: **Tue Jul 10, 2007 11:42 pm**

Of course, if you were to contemplate TWO database stages, the answer would probably be more to your liking.

DSXchange

Fetching two databases from single database Stage

Fetching two databases from single database Stage