ALLInterview.com :: Home Page            
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
tip   SiteMap shows list of All Categories in this site.
Google
   
 
Categories  >>  Software  >>  ERP CRM  >>  SAP  >>  SAP B1
 
 


 

 
 Basis interview questions  Basis Interview Questions
 ABAP interview questions  ABAP Interview Questions
 SAPScript interview questions  SAPScript Interview Questions
 SD interview questions  SD Interview Questions
 MM interview questions  MM Interview Questions
 QM interview questions  QM Interview Questions
 PP interview questions  PP Interview Questions
 PM interview questions  PM Interview Questions
 PS interview questions  PS Interview Questions
 FI CO interview questions  FI CO Interview Questions
 HR interview questions  HR Interview Questions
 SAP CRM interview questions  SAP CRM Interview Questions
 SRM interview questions  SRM Interview Questions
 APO interview questions  APO Interview Questions
 Business Warehouse interview questions  Business Warehouse Interview Questions
 Business Workflow interview questions  Business Workflow Interview Questions
 SAP Security interview questions  SAP Security Interview Questions
 SAP Interfaces interview questions  SAP Interfaces Interview Questions
 Netweaver interview questions  Netweaver Interview Questions
 SAP ALE IDocs interview questions  SAP ALE IDocs Interview Questions
 SAP B1 interview questions  SAP B1 Interview Questions
 SAP AllOther interview questions  SAP AllOther Interview Questions
Question
How you approach when you find that your process chain take
a lots of time for loading,tell me the step to increase the
loading performance,
 Question Submitted By :: Sekhar02.info
I also faced this Question!!     Rank Answer Posted By  
 
  Re: How you approach when you find that your process chain take a lots of time for loading,tell me the step to increase the loading performance,
Answer
# 1
Data load has to be checked through RSMO. In which, data
load status to be monitored.

It might be problem with connectivity b/w BI and Source
system or it might be because of data load package size. If
it takes longer than normal load time, then mostly package
load will fail.

For that, data load has to be started manually.

NOTE: Data load mustn't be stopped in middle for ETL
process through PC.

Tocheck for connectivity we use SM59.
 
Is This Answer Correct ?    0 Yes 0 No
Saravana
 
  Re: How you approach when you find that your process chain take a lots of time for loading,tell me the step to increase the loading performance,
Answer
# 2
1) change log clean up.
In RSPC > Use process type 'Deletion of request from change log'. In process chain variant options > enter no of days for data in change log to be cleaned.

2)Use RSPC_LOG_DELETE to delete old logs.>> specify the time period for the old logs to be deleted.

3) if "delete index" and "create index" process types are there in process chain then remove those process types and create a separate chain with them.Schedule this chain when the load is low.

4) Check for table space in DB02/DB02OLD and contact basis.

5)Kill the long running backend jobs in sm66/sm50
 
Is This Answer Correct ?    3 Yes 0 No
Guest
 
 
 

 
 
 
Other SAP B1 Interview Questions
 
  Question Asked @ Answers
 
1. We have standard info objects given in sap why you created zinfo objects can u tell me the business scenario 2. We have standard info cubes given in sap why you created zinfo cubes can u tell me the business scenario 3. In keyfigure what is meant by cumulative value, non cumulative value change and non cumulative value in and out flow. 4. when u creating infoobject it shows reference and template what is it 5. what is meant by compounding attribute tell me the scenario? 6. I have 3 cubes for that I created multiprovider and I created a report for that but I didn’t get data in that report what happen? 7. I have 10 cubes I created multiprovider I want only 1 cube data what u do? 8. what is meant by safety upper limit and safety lower limit in all the deltas tell me one by one for time stamp, calender day and numberic pointer? 9. I have 80 queries which query is taking so much time how can you solve it 10. In compression level all requests are becoming zero which data is compressing tell me detail 11. what is meant by flat aggregate?explain in detail 12. I created process chain 1st day it taking 10 min after that 1st week it taking 1 hour after that next time it taking 1 day with a same loads what happen how can u reduce the time of loading 13. how can u know the cube size? in detail show me u have screen shots 14. where can we find transport return codes 15. I have a report it taking so much time how can I rectify 16. what is offset? Without offset we create queries? 17. I told my process chains nearly 600 are there he asked me how can u monitor I told him I will see in rspcm and bwccms he asked is there any third party tools is there to see? Any tools are there to see tell me what it is 18. how client access the reports 19. I don’t have master data it will possible to load transaction data? it is possible is there any other steps to do that one 20. what is structure in reporting? 21. which object based you created extended star schema? 22. what is line item dimension tell me brief 23. what is high cardinality tell me brief 24. 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 25. what is direct schedule and what is meta chain 26. which patch u used presently? How can I know which patch that one? 27. how can we increase data packet size 28. hierarchies are not there in bi?why 29. remodeling is applied only on info cube? why not dso/ods? 30. In jump queries we can jump any transactions just like rsa1, sm37 etc it is possible or not? 31. why ods activation fail? What types of fails are there? What are the steps to handle 32. I have a process chain is running the infopackage get error don’t process the error of that info package and then you can run the dependent variants is it possible? TCS5
) Why is there a restriction of 16 Dim tables in an Info Cube and 16 key fields in an ODS.  3
Difference between filter and condition in sap bi IBM1
WHERE DO YOU STORE THE MASTER DATA IN BI 7.0  7
your process chain link with ABAP Program,suppose your ABAP Code need some changes how you do this(your process chain is in running stage) Accenture1
how to write a customise code in reporting replacement path HCL1
How does cell editor works in BEx. TCS1
Can we format BEx reports/graphs using HTML and CSS  1
Hi,Could you plz explain me Diff between transfer rule&update rules  2
Hi Experts, 1. Can any one tell about how to know the Cube size 2. How to delete single Wrong transaction in Cube SAP-Labs2
Hi, I am currently working in midsized company in SAP Business One after getting two years experience can i move to MNC company with SAP B1 or can i change technology to SAP ABAP na Please suggest me......  1
what is concept behind incoming payment and outgoing payment? Wipro2
 
For more SAP B1 Interview Questions Click Here 
 
 
 
 
 


   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us interview questions urls   External Links 
   
Copyright © 2012  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com