Input types to TPUMP ?

Tools & Utilities

Input types to TPUMP ?

Hi

My situation is we need to load a million of data from SQL Server to Teradata, But we should use TPUMP for it

My Question is does TPUMP supports database as input to it ?, if yes plz explain

Thanks in advance
2 REPLIES
Enthusiast

Re: Input types to TPUMP ?

Hi,

Your file should be input. See what are the paramters you need to set: sessions(min ,max),pack,serialize off/on,checkpoint, robust on/off,monitor after .begin load . Your input should be import infile xxxx layout urlayout....apply urdml.....

Just in case you use tool, say abinitio as example, you can load from one db to another after configuring your dbc file.

Enjoy,
Raja
Enthusiast

Re: Input types to TPUMP ?

TPump is not the ideal tool for moving a million records around - it is much slower than Fastload or Mload, and uses a lot more resource!

Best way is to export the data to a flat file or pipe it directly into a Fastload or Multiload using a host which has access to both the SQL Server and Teradata systems.