All Forums Database
raj_2008 18 posts Joined 07/11
15 Jul 2015
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

nagendratrpth 25 posts Joined 03/14
15 Jul 2015

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
 
 

raj_2008 18 posts Joined 07/11
27 Jul 2015

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

You must sign in to leave a comment.