SAP BI/BW Interview Questions and Answers

SAP BI/BW Interview Questions and Answers

Here, we have listed all the Top SAP BI/BW Interview Questions and Answers for Freshers & Experienced. All the best for your interview Preparation.

What is SAP BW/BI? What is the purpose of SAP BW/BI?

What are the main areas and activities in SAP/BI?

What is data Integrity?

What is table partition?

What is data flow in BW/BI?

What is ODS (Operational Data Store)?

What is an ‘Infocube’?

How many tables does infocube contain?

what are the maximum number of dimensions in infocubes?

What is the difference between ODS and Infocube?

What is the dimension in BW? How would you optimize the dimensions?

What are info objects?

What is modelling?

What is extended star schema?

What are the extractors and mention their types?

What is a ‘Fact Table’?

What are the data types for the characteristics info object?

What is the use of the process chain?

What are the transaction codes or T-codes for Info-objects?

What is the maximum number of key figures and characteristics?

How can you convert an info package group into the process chain?

Can an Info-object be an Info-provider?

What is multi-provider in SAP BI? What are the features of Multi providers?

What is Conversion Routine?

What is the difference between the Start routine and Conversion routine?

How to un-lock objects in Transport Organizer?

What is update or transfer routine?

What are the types of Multi-providers?

What are the transaction codes for process chain?

What is the T.code for Data Archival and what is the advantage?

What is BEx Map in SAP BI?

What is B/W statistics and how it is used?

What is the data target administration task?

What are the options when defining aggregates?

What do you mean by the term ‘slowly changing dimension’?

Explain how you can create a connection with LIS Info Structures?

What are the delta options available when load from flat file?

What are the steps within SAP BI to create classes for BW?

What is data ware-housing hierarchy?

How will you debug errors with SAP GUI ?