Loading from Oracle Warehouse Builder to Teradata

UDA

Loading from Oracle Warehouse Builder to Teradata

Do we have the external loaders for loading the data into teradata from Oracle Warehouse Builder or do we need to generate flat files and then write the mload/fload scripts explicitly for loading into Teradata ?
2 REPLIES
Enthusiast

Re: Loading from Oracle Warehouse Builder to Teradata

I dont think OWB can have Teradata as target database. It can have Teradata as source database.

Re: Loading from Oracle Warehouse Builder to Teradata

Oracle® Warehouse Builder
Sources and Targets Guide
11g Release 2 (11.2)
E10582-03

Table 1–1 Sources and Targets Supported in Oracle Warehouse Builder 11g Release 2 (11.2)

Supported Targets:
Any database accessible through
Oracle Database Heterogeneous
Services, including but not limited
to DB2, Informix, SQL Server,
Sybase, and Teradata.