Partitioning Details

saikir · Post by **saikir** » Wed Feb 11, 2009 4:15 am

Hi All,

I would like to know whether there is any Universe table in PX that stores the partition details stage wise?

Regards,
Sai

ray.wurlod · Post by **ray.wurlod** » Wed Feb 11, 2009 5:12 am

There is no separate table.

Design-time partitioning is stored as a set of properties of the stage (that is, of the particular job object), in DS_JOBOBJECTS. Run-time partitioning is stored in the RT_CONFIGnnn table for job number nnn.

saikir · Post by **saikir** » Wed Feb 11, 2009 5:19 am

Hi Ray,

Thanks a lot. I can't read most of the content as i am not a premium member. Can you please make the content visible?

Regards,
Sai

ray.wurlod · Post by **ray.wurlod** » Wed Feb 11, 2009 5:21 am

Yes I can, but I won't.

Premium membership is not expensive, at less than 30c (Rs12) per day, and is one of the ways that the hosting and bandwidth costs of DSXchange are met.

I do not propose to set any precedent that might undermine the ongoing viability of DSXchange.

kduke · Post by **kduke** » Wed Feb 11, 2009 1:02 pm

EtlStats has been modified to gather row counts at this level. It really ups the rows stored per ETL run. Lets say you have 200 jobs with average 20 stages and you run with an 8 way config. That is 200*20*8 rows in ETL_ROW_HIST per run. We have 40,000 rows per day in one or more projects.

By the way I have not posted the new EtlStats. I posted how to make the change so you can do it yourself if you want.