BW Interview Questions for Freshers

  1. How many tables are there in different types of DSO? What is the function of change log in DSO table?
  2. What are the common process chain issues you have encountered? How to resolve them?
  3. What is LSA architecture? How it is different from LSA++?
  4. What is compression? Is it possible to delete data from cube after compression? If yes, how?
  5. What is LO extraction, how it is different from FI extraction?
  6. How you will optimize the query performance?
  7. What is extended star schema design? How it is different from star schema and snow flake schema?
  8. Explain line item dimension, how it is different from high cardinal flag?
  9. What is read master data type rule in a transformation? When to use it?
  10. What is the difference between V1, V2 and V3 updates?
  11. What is delta queue, how it is different from extraction queue?
  12. What is Direct Delta? How it is different from Queued Delta and Unserialized V3 updates?
  13. What is generic Data source? When to use it?
  14. What are the different types of variables in query designer?
  15. What are the different types of processing type for variables in BEx?
  16. What is replacement path processing type? Give an example.
  17. What is Infosource? When to  use it?
  18. Name some of the standard datasources from business content.
  19. What is pseudo delta? When to use it?
  20. How to schedule process chain? How to stop a running process chain?
  21. How to check the size of F and E fact tables for cubes in a BW system?
  22. What is Attribute Change run? How it is different from ‘Activate master data’?
  23. What steps to take to progress an info package stuck due to TRFCs in source system?
  24. Your query data is not matching with the source, how you will go about in finding the root cause?
  25. What is error DTP? when to use it?