My source is Oracle, and my staging tables are in Teradata. Should I create staging tables with PI or shall I create NOPI tables?
What is recomanded?
NOPI tables have been designed specifically for staging tables in order to avoid amp skewness, as at this step you do not have any well defined PI for data distribution.
I think you can use NOPI for good performance and good random distribution.