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                      
Google
   
 
Categories >> Software >> ERP CRM >> SAP >> SAP B1
 
 


 

 
 Basis interview questions  Basis Interview Questions (812)
 ABAP interview questions  ABAP Interview Questions (2422)
 SAPScript interview questions  SAPScript Interview Questions (127)
 SD interview questions  SD Interview Questions (1944)
 MM interview questions  MM Interview Questions (348)
 QM interview questions  QM Interview Questions (8)
 PP interview questions  PP Interview Questions (133)
 PM interview questions  PM Interview Questions (21)
 PS interview questions  PS Interview Questions (20)
 FI CO interview questions  FI CO Interview Questions (1645)
 HR interview questions  HR Interview Questions (434)
 SAP CRM interview questions  SAP CRM Interview Questions (261)
 SRM interview questions  SRM Interview Questions (11)
 APO interview questions  APO Interview Questions (18)
 Business Warehouse interview questions  Business Warehouse Interview Questions (622)
 Business Workflow interview questions  Business Workflow Interview Questions (9)
 SAP Security interview questions  SAP Security Interview Questions (332)
 SAP Interfaces interview questions  SAP Interfaces Interview Questions (4)
 Netweaver interview questions  Netweaver Interview Questions (144)
 SAP ALE IDocs interview questions  SAP ALE IDocs Interview Questions (47)
 SAP B1 interview questions  SAP B1 Interview Questions (57)
 SAP AllOther interview questions  SAP AllOther Interview Questions (90)
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 :: SAP-B1
I also faced this Question!!     Answer Posted By  
 
Answer
# 1
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 ?    4 Yes 0 No
Guest
 
Answer
# 2
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
 
 
 

 
 
 
Other SAP B1 Interview Questions
 
  Question Asked @ Answers
 
can we load delta load directly without full load ? how ? what are the steps IBM 2
) Why is there a restriction of 16 Dim tables in an Info Cube and 16 key fields in an ODS.   3
Hi,Could you plz explain me Diff between transfer rule&update rules   2
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? TCS 6
Hi Experts, What are the common Transport errors in SAP BW? TCS 1
what is report to report interface and why we use it sap bi Atos-Origin 1
Can anybody explain the what is "OLTP"(Online Transaction Processing) and "OLAP"(Online Abaytical Processing) in SAP BW/BI? and also plz explain What is the differences between those two? Thanks in advance, Phani   5
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, Accenture 2
What is the difference between canceling the sales order and closing the sales order?   2
how to get certification for SAP B1? What are all the institutes in mylapore and T-Nagar for SAP B1? SAP-Labs 1
what is the techincal name for dimensions in a cube? IBM 7
what is the difference between DBCONNECT AND UDCONNECT IN SAP BI SYSTEM   1
 
For more SAP B1 Interview Questions Click Here 
 
 
 
 
 


   
Copyright Policy  |  Terms of Service  |  Articles  |  Site Map  |  RSS Site Map  |  Contact Us
   
Copyright © 2013  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  KalAajKal.com