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?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / thiru
it depends on so many reasons , because of network
problem,and also increase the no of records also
Is This Answer Correct ? | 1 Yes | 9 No |
What is early delta initialization?
1.What is exception Aggregation? give Example? 2.what Cell formating? and Advantages?
How does delta update mechanism work in ods?
When should you do the alpha conversion?
what is DSO? what are the types and uses and in which case it suppose to be use?
Define the update rule?
What are the uses of data marts?
Explain about the dimension in the warehouse?
what is infoproviders in sap bi?
What is the transaction for process chain?
iam looking for some scenarion on reporting concepts like - replacement path,customer exits, all types of variables. plese send me some important links and materials. so it will be helpful for me. thanks in advance
What are the settings for data transfer?