How do you analyse the data loading time ...today the
loading time is 15 min.but tomorrow the same type of
loading takes 3 hours..How do you analyse?

Answer Posted / soumyajit

There can be many reasons:-

1)Data Records can be more.
2)System performance of Source or BW system can be poor.
3)Lot of other extraction going on from the same source
system.
4)TRFC stucked in TRFC queue.
5)Temporary Table space is less in BW.
6)Target is already locked by some other job.

Is This Answer Correct ?    12 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What does rollup do?

578


What is the difference between sap bw 3.0b and sap bw 3.1c, 3.5?

479


What is extended star schema?

535


How do you transform open hub data?

648


What is an infocube? What are its different types?

494






List the steps to do the creating classes in sap-bw

496


What are the conversion routines for units and currencies in the update rule?

488


How to get the recordmode D or A in changelog table when we delete or add records in DSO?

5231


How would you convert an info package group into a process chain?

601


How do you convert web objects from 2.x to 3.x?

1521


process chain is running I have to stop the process for 1 hour after that re runn the process where it is stopped? in multiprovider can I use aggregations

1206


What is an infocube?

529


What internally happens when bw objects like info object, info cube or ods are created and activated?

603


What are the types of reports you can use in reporting agent?

1605


How is ?:? useful as an authorization value?

1502