Question:
hello
I am getting the warning when i am scheduling the data directly to Data target.
The warning is:
InfoCube : Name (T name)
InfoCube should be loaded
The InfoCube indices will be deleted upon loading
Therefore, the read performance will be temporarily impaired
Do you want to continue anyway?
why i am getting this warning???
please tell me
Thanks
Nemo
_________________
Nemo
www.FreeSofty.com
_______________________________________
Smile is the sign of beautiful world.
Answer:
Ignore this message, go ahead with loading.
Answer:
why i am getting this warning???
You get this warning because you have set up an automatic delete/refresh of the statistics and indexes on your info provider.
These are improving performance of running queries against this info provider. While you reload or load new data these indexes will be de-activated and then recreated after the load. During this load time, the performance of running this query might be affected. Therefore if you plan to load a big load for many hours you should consider if this should be done at a time when as few as possible are using the system and running queries against this info provider.
Kind regards
/martin
Answer:
hi martin,
where we set this thing???
can you please tell me what is the path for this process?
Thanks
Nemo
_________________
Nemo
www.FreeSofty.com
_______________________________________
Smile is the sign of beautiful world.
Answer:
Hi,
If you select manage on your info cube. Then go to tab "Performance". In there under indexes for example yo have the button "(Create Index (Batch)). If you click on that button and put a check mark in the "delete before each load" this will then be the cause of the warning you get when loading data.
You can also set this in a Process Chain where this is a Process Type.
Kind regards
/martin