Calculating memory usage for SCD

[tkbharani]

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 ?

[SURA]

It could be for the whole job:

You can use ps -o | grep job name. Then you can calculate.

Right now i am not in front of system (now in windows) to check this! But it should work.

Or

You can try pmap kind of command.