Should I create staging tables with PI or shall I create NOPI tables?

General
Enthusiast

Should I create staging tables with PI or shall I create NOPI tables?

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?

Thanks,

Sayak.G

1 REPLY
Enthusiast

Re: Should I create staging tables with PI or shall I create NOPI tables?

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.

Khurram