Teradata-Retrieve data from tables in Multiple databases

Aparna_A · Post by **Aparna_A** » Thu Jan 01, 2009 9:51 pm

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.

chulett · Post by **chulett** » Thu Jan 01, 2009 10:42 pm

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.

hamzaqk · Post by **hamzaqk** » Fri Jan 02, 2009 1:06 am

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.

Aparna_A · Post by **Aparna_A** » Fri Jan 02, 2009 5:06 am

Hi,

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

hamzaqk · Post by **hamzaqk** » Sun Jan 04, 2009 11:00 pm

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