loading almost 10 billon records into teradata table

Tools & Utilities
Enthusiast

loading almost 10 billon records into teradata table

Hi,

 

I have a file containing almost 10 billion records. These records need to be inserted into a blank teradata table. Please suggest me the best utility to do it. Table is not a stage table or NUPI based table. The table is blank but has a primary index in it.

 

Thanks,

Deborshi Chakraborty

1 REPLY 1
Highlighted
Teradata Employee

Re: loading almost 10 billon records into teradata table

Hi.

 

Big file into an empty table suggest TPT LOAD operator or fastload utility as first approach.

 

Cheers.

 

Carlos.