Loading Mutiple Oracle source table into 1 tale in Teradata

Tools & Utilities

Loading Mutiple Oracle source table into 1 tale in Teradata

Hi,

I have a requirment to move the data from 16 instanaces in Oracle to 1 table in Teradata using single script.

Lets say i have a customer table in 16 different schemas/instances with same layout in Oracle, my requirment is to load all these 16 customer table from Oracle into one single customer Table in Teradata. What utlity should i use and how to acheive this.

Please help!

Tags (1)
1 REPLY
Enthusiast

Re: Loading Mutiple Oracle source table into 1 tale in Teradata

My suggestion : join all what you have in Oracle and treat it as one source , to avoid I/O, Cpu, network ..... issues and then proceed with usl.

Just a while back someone asks something similar:

http://forums.teradata.com/forum/connectivity/create-a-teradata-view-to-an-external-teradata-server

In that link, there are references to USL and upcoming features, simalar to all Oracle db link features maybe.