Fetching two databases from single database Stage

vermarah · Post by **vermarah** » 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.

chulett · Post by **chulett** » Tue Jul 10, 2007 11:25 pm

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

ray.wurlod · Post by **ray.wurlod** » 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.