All Forums Tools
Malleshkr 11 posts Joined 08/12
27 Jan 2015
Need to load from Table 1 to Table 2. Which utility work well here and WHY?

Need to load from Table 1 to Table 2. Which utility work well here and WHY?
Please explain the limitations and advantages against each utility.

_Mallesh
ulrich 816 posts Joined 09/09
28 Jan 2015

On the same TD DB server?

feel free to donate bitcoin:12kgAUHFUqvG2sQgaRBXFhCwyf9HXdkGud

Malleshkr 11 posts Joined 08/12
28 Jan 2015

Yes. its same Teradata Server.
Also, when we are doing from DB to DB, Server to Server scenario as well. Please.

_Mallesh

ulrich 816 posts Joined 09/09
28 Jan 2015

SQL will be your choice of the same Server.
It will depend on your environment and the szenario if you call it from BTEQ, Teradata Studio or an Python / Java script. The data will not leave the system.
Server to Server - again, what is your setup? Which ETL tool do you use? Big volumes; TPT, Arcmain, Unity data mover (which is using TPT or Arcmain) are the tools of choice. There exists many threads on this in this forum. Check for these.
Very generic question. Without getting specific backgroud you will not get sufficient answers.
 

feel free to donate bitcoin:12kgAUHFUqvG2sQgaRBXFhCwyf9HXdkGud

You must sign in to leave a comment.