All Forums Tools
JKerena 1 post Joined 02/14
14 Oct 2014
Loading Mutiple Oracle source table into 1 tale in Teradata

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:
In that link, there are references to USL and upcoming features, simalar to all Oracle db link features maybe.

Raja K Thaw
My wiki:
Street Children suffer not by their fault. We can help them if we want.

You must sign in to leave a comment.