Need Help

[subbareddykm]

Hi All,

I have some some question regarding optimizing QV application.

1.Present my application is taking reload time 2 and half an hour.

2.i want to reduce that time ? How ? Tell me some possible ways.even i m using All QVD's only.

3.Also i have five fact table .How do i make  single fact table. There iss no lnk between thosa fact tables ....

[Colin-Albert]

If you are joining 4 fields, then this will need 4 mapping tables and 4 apply maps. It should run much faster than a join though and avoids errors caused by incorrect joins causing data to duplicate.

I create the multiple mapping tables rather than using join wherever possible,

There are more details on the pros & cons here Don't join - use Applymap instead

[Colin-Albert]

There is a good blog by Steve Dark on ApplyMap here as well

http://www.quickintelligence.co.uk/applymap-is-it-so-wrong/

[Colin-Albert]

For testing use Debug mode, and set a limited load of 10, 100 or 1000 rows.

This will allow you to test your script without loading all the data and so will not take 2+ hours for each test.

[subbareddykm]

OKay well,

I want to ask you one thing if my QVD present in Production server and if reload in Development server,will it effect on reload time ?