DSXchange

Hi,

Using a Teradata Enterprise Stage, Could anyone pls. let me know how to retrieve data by joining tables available in different databases.

When Database option is not set, the stage tries to read from default user database, but I have to read data from 2 databases other than user default database.

When Database option is set, we cna read data from only a single database.

Pls. help.

How would you do this outside of DataStage? In Oracle, for example, one would create a dblink between them, there must be a similar technique for Teradata.

are you trying to export the data in the same stage ? specify the fully qualified SQL statement in the user defined SQL to fast export the data. Not sure why are you using this but would be a good idea to use the Multiload to do this.

Hi,

I used fully qualified name and was able to retrieve data..
Can you elaborate how a multiload stage helps in this scenario..

more flexible and less bugs as compared to the enterprise stage.