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 ?
There is an article in the forum on NoPI , Please go through this :
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 ?