All Forums Database
Jigar 70 posts Joined 09/11
04 Dec 2012
Skewness in nopi Table

Hi ,
I have table where loading data from flat files and all the tables appear to be skewed more than 95%. All these tables are no pi ,
Is there any way or reason why these tables would be skewed or any way to avoid it , apart from actually having a PI.

Jigar 70 posts Joined 09/11
05 Dec 2012


ToddAWalter 316 posts Joined 10/11
05 Dec 2012

How did you load the data into the table?
How many rows did you load into the table?
How big is the system?

Jigar 70 posts Joined 09/11
06 Dec 2012

It has 15 nodes, loaded data using stream utility via Informatica..and issue is observed across tables with varying length..having 50000 rows to 10 million..

Harpreet Singh 101 posts Joined 10/11
10 Dec 2012

Have you tried load, update utility? is there any difference in skewness?

You must sign in to leave a comment.