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.
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.