Usage of Staging tables with NoPI and Insert/Select

Database
Enthusiast

Usage of Staging tables with NoPI and Insert/Select

Hi,

It is often recommended to first load the data to a Staging table with NoPI and then use Insert/Select to load the data from the Staging table to the base/production tables vs loading the data directly to the base/production table(s).

What is the performance benefit realized from this and how exactly does this approach result in the performance improvement against loading the data directly to the base table ?

Thanks,

Raj

Tags (1)
2 REPLIES
Enthusiast

Re: Usage of Staging tables with NoPI and Insert/Select

There is an article in the forum on NoPI , Please go through this :

http://developer.teradata.com/database/articles/say-yes-to-no-primary-index-no-pi-tables

Enthusiast

Re: Usage of Staging tables with NoPI and Insert/Select

Hi,

Thanks for pointing me to the post. It was really helpful. However, here is a question pertaining to a statement in the post -

"....its rows can be dispatched to any given AMP arbitrarily, so the system can load data into a staging table faster and more efficiently."

Question - If rows are dispatched to any given AMP arbitrarily, then does not it open a possiblility for skew in the table ? 

Thanks