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?
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