Need to load from Table 1 to Table 2. Which utility work well here and WHY?

Tools & Utilities
Enthusiast

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.

3 REPLIES
Senior Supporter

Re: Need to load from Table 1 to Table 2. Which utility work well here and WHY?

On the same TD DB server?

Enthusiast

Re: Need to load from Table 1 to Table 2. Which utility work well here and WHY?

Yes. its same Teradata Server.

Also, when we are doing from DB to DB, Server to Server scenario as well. Please.

Senior Supporter

Re: Need to load from Table 1 to Table 2. Which utility work well here and WHY?

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.