How to calculate dataset size created during job execution

yjoshi · Post by **yjoshi** » Wed Aug 13, 2008 7:54 pm

Need to estimate disk space required at any give point for DS job dataset created.Any formula or thumb fo rule to estimate

kduke · Post by **kduke** » Wed Aug 13, 2008 8:18 pm

If you save the metadata for the column names in the link for the dataset then there is a routine in my downloads on my tips page to estimate disk space based on the length on records saved in DataStage. The source code is included so you can tweak the calculations. I think I used 80% of a varchar length. You need to make sure RCP is turned off going to this link otherwise you have columns which you may not know are there.