need to help

[#1]

Hello team

   in my report one table is getting 21 lakhs records, but once it is getting loaded report got hanged. Can any one help me what need to be done

[its_anandrjs]

1.Also check your data model by click on the Ctrl+T to view any synthetic keys created or not by checking the synthetic tables may be due to that reason the applications also hangs.

2. Or check there is huge nested If conditions on the application if so then make simple way.

3. May be check for SCD ( Slowely changing dimensions) due to that the application may be getting slow check this also.

Hope this helps

[ashfaq_haseeb]

Hi,

May be you need to look at ram.

Are you running short of ram?

Monitor your ram consumption after reload.

If required you need to increase RAM.

Regards

ASHFAQ