Here you can find SAP BW Interview Questions and Answers.
In this SAP BW Interview Questions and Answers section you can learn and practice SAP BW Interview Questions and Answers to improve your skills in order to face technical inerview by IT companies. By Practicing these interview questions, you can easily crack any SAP BW interview.
AllIndiaExams provides you lots SAP BW Interview Questions and Answers with proper explanation. Fully solved examples with detailed answer description. All students, freshers can download SAP BW Interview Questions and Answers as PDF files and eBooks.
You no need to worry, we have given lots of SAP BW Interview Questions and Answers and also we have provided lots of FAQ's to quickly answer the questions in the SAP BW technical interview.
What is SAP BW/BI? What is the purpose of SAP BW/BI?
SAP BW/BI stands for Business Information Warehouse, also known as business intelligence. For any business, data reporting, analyses and interpretation of business data is very crucial for running business smoothly and making decision. SAP BW/BI manage the data and enables to react quickly and in line with the market. It enables the user to analyze data from operative SAP applications as well as from other business.
In SAP/BI what are the main areas and activities?
a) Data Warehouse: Integrating, collecting and managing entire company’s data. b) Analyzing and Planning: Using the data stored in data warehouse c) Reporting: BI provides the tools for reporting in web-browser, excel etc. d) Broad cast publishing: To send the information to the employees using email, fax etc. e) Performance: Performance of the company f) Security: Securing the access like using SAP logon tickets from portal
What is data Integrity?
Data integrity is to eliminate duplicate entries in the database.
What is table partition?
Table partition is done to manage the huge data to improve the efficiency of the applications. The partition is based on 0CALMONTH and 0FISCPER. There are two type of partitioning that is done a) Database partitioning b) Logical partitioning
What is data flow in BW/BI?
Data flows from a transactional system to the analytical system (BW). DS ( Data Service) on the transactional system needs to be replicated on BW side and attached to infosource and update rules respectively.
What is ODS (Operational Data Store)?
‘Operational Data Store’ or ‘ODS’ is used for detailed storage of data. It is a BW architectural component that appears between PSA ( Persistent Staging Area) and infocubes, it allows BEX (Business Explorer) reporting. It is primarily used for detail reporting rather than dimensional analysis, and it is not based on the star schema. ODS (Operational Data Store) objects do not aggregate data as infocubes do. To load the data into an IDS object, new records are inserted, existing records are updated, or old records are deleted as specified by RECORDMODE value.
What is an ‘Infocube’?
Infocube’ is structured as the star schema and it is a data storage area. To create an infocube, you require 1 ‘fact table’ surrounded by 4 dimensions. The ‘fact table’ is surrounded by different dim table, which are linked with DIM’ ids. And as per the data, you will have aggregated data in the cubes.
How many tables does info cube contain?
Info cubes contain two tables, E table and F (fact table).
Mention what are the maximum number of dimensions in info cubes?
In info cubes, there are 16 dimensions ( 3 sap defined and 1 customer defined)
What is the difference between ODS and Info-cubes?
The difference between ODS and Info-cubes are a) ODS has a key while Info-cubes does not have any key b) ODS contains detailed level data while Info-cube contains refined data c) Info-cube follows Star Schema (16 dimensions) while ODS is a flat file structure d) There can be two or more ODS under a cube, so cube can contain combined data or data that is derived from other fields in the ODS