All Forums Tools
JKerena 1 post Joined 02/14
14 Oct 2014
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!
 
 
 

Raja_KT 1246 posts Joined 07/09
14 Oct 2014

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.

Raja K Thaw
My wiki: http://en.wikipedia.org/wiki/User:Kt_raj1
Street Children suffer not by their fault. We can help them if we want.

You must sign in to leave a comment.