Mload Vs Insert/Select on a BIG table with PPI

Tools
Teradata Employee

Mload Vs Insert/Select on a BIG table with PPI

Hi all.

I'm having some doubts about which strategy to follow in order to load information on a big table.
The situation is this: the table will hold info for about 6 months, and diary will load about 100 million records. The table will also have a PPI by day.

My doubt is if the job that loads the records should be a mload given the size of the table, or if using the PPI I could do an Insert/Select given that the partition of the day to be loaded is empty (ideally).

thanks.
2 REPLIES

Re: Mload Vs Insert/Select on a BIG table with PPI

Where are the data to load? In a file or in another table in Terdata?

Re: Mload Vs Insert/Select on a BIG table with PPI

it looks like fastload to a staging table followed by an insert/select would work well for you ....