All Forums Database
KVB 124 posts Joined 09/12
03 Apr 2014
Execution time for PI and NoPI for 30 million records is same

Hi
I have loaded a table using with 4 million records a my source file with PI and with NoPI using TPT connection.It shows a gain.
When I load a 30 million record file with PI and with NoPI.It does not show much gain.Almost the execution times are same.
Any comments on this?

krishaneesh 140 posts Joined 04/13
07 Apr 2014

Skew might be the distinguishing factor. Can you check the skew factor with the PI for the 4 million and 30 million records. if the skew percentage is high then it takes more time to load a PI based table than a NOPI table

You must sign in to leave a comment.