DSXchange

Hi there,


I dont have a parallel version with me, but have a doubt regarding it while discussing with my friend.

Can we extract data by using single oracle stage from two different schemas using SQL statements??? Can one stage be used to connect to two schemas?

eg :

select A.id,
A.dat1,
A.dat2,
B.id,
B.dat1

from
schema1 A,
schema2 B

where
A.id=B.id

Can we do this??

Regards

If yopu can execute this SQL statement with your query tool, then you can do so in PX as well.

Two schemas in the same instance? Sure. Two instances would require dblinks.