Search This Blog

Sunday, 28 December 2014

Database Overview .

Before Learning SAP BO , You Have To Understand Few Common Concept Of Database That Will Help Full For Your Understanding while You Are Creating Any Analysis Report For Top Level Management.



List of Question 

  1. What is Data warehouse?
  2. What is Data mart?
  3. What is Rapid Mart?
  4. What is the difference between OLTP and OLAP?
  5. What are the types of Dimensions?
  6. What is Confirmed Dimension?
  7. What is Junk Dimension?
  8. What is Degenerate Dimension?
  9. What are Degenerated Objects?
  10. What is Role playing Dimension?
  11. What is Casual Dimension?
  12. What are slowly changing dimensions?
  13. What are the types of slowly changing dimension (SCD)?
  14. What is MOLAP? (Multidimensional)
  15. What is ROLAP? (Relational)
  16. What is HOLAP?
  17. What is Dimension Modeling?
  18. What is Fact table?
  19. What is Dimension table?
  20. What are the different measure (fact) types?
  21. What is ODS (Operational Data Store)?
  22. What is a Star schema?
  23. What is a Snowflake schema?
  24. What is the difference between Star and Snow flake schema?
  25. What is the use of AFD? Where it can be stored?
  26. What is Data Integrator (BODI)?
  27. What is Data Federator?
  28. Are data mart and data warehouse normalized or de-normalized? Can both exist in same tier?
  29. Explain BO architecture?
  30. What are the different authentication modes you know?
  31. What is Semantic layer?
  32. What is meant by ZABO?

No comments:

Post a Comment