Thursday 5 February 2015

90 TOP SAP BI/BW Interview Questions and Answers (Part1)

Below are some important SAP BW interview questions which are asked in most MNC company interviews for beginners or professionals.
1) Please describe your experience with BEx (Business Explorer)
A) Rate your level of experience with BEx and the rationale for you’re self-rating
B) How many queries have you developed? :
C) How many reports have you written?
D) How many workbooks have you developed?
E) Experience with jump targets (OLTP, use jump target)
F) Describe experience with BW-compatible ETL tools (e.g. Ascential)

2) 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.

3) Describe your experience with the design and implementation of standard & custom InfoCubes.
1. How many InfoCubes have you implemented from start to end by yourself (not with a team)?
2. Of these Cubes, how many characteristics (including attributes) did the largest one have.
3. How much customization was done on the InfoCubes have you implemented?

4) What is data Integrity?
Data integrity is to eliminate duplicate entries in the database.

5) 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

6) 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.

7) Describe your experience with BW extractors
1. How many standard BW extractors have you implemented?
2. How many custom BW extractors have you implemented?

8) Describe how you have used Excel as a compliment to BEx
A) Describe your level of expertise and the rationale for your self-rating (experience with macros, pivot tables and formatting)B)

9) 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.

10) 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
More Questions & Answers :-

No comments:

Post a Comment