Calculating memory usage for SCD
Posted: Wed Sep 26, 2012 5:56 pm
Hi,
I am using SCD stage to maintain Dimension tables. The volume of data is more than 20 Million records. What would be the process or steps to calcualte the memory usage of the job or scd stage. Some times the jobs uses maximum of RAM and other jobs does not have sufficient memory.
Should I use "nmon" in unix to monitor the memory? How to calculate the rows to memory approximately ?
I am using SCD stage to maintain Dimension tables. The volume of data is more than 20 Million records. What would be the process or steps to calcualte the memory usage of the job or scd stage. Some times the jobs uses maximum of RAM and other jobs does not have sufficient memory.
Should I use "nmon" in unix to monitor the memory? How to calculate the rows to memory approximately ?