|
|
|
Forum Newbie
Group: Forum Members
Last Login: 9/16/2009 7:13:00 AM
Posts: 2,
Visits: 23
|
|
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
SAT!SH
|
|
|
|
|
Forum Member
Group: Forum Members
Last Login: 10/22/2009 1:29:06 AM
Posts: 36,
Visits: 182
|
|
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
Teradata_cert_Oracle_cert
|
|
|
|
|
Supreme Being
Group: Forum Members
Last Login: Yesterday @ 3:55:54 AM
Posts: 111,
Visits: 263
|
|
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.
|
|
|
|