100 TOP SAP BI Interview Questions and Answers pdf free download

1)  What is business intelligence?
2)  What is OLAP?
3)  What is data integrity?
4)  What is the difference between SAP BW 3.0B and SAP BW 3.1C, 3.5?
5)  What is the difference between SAP BW 3.5 and 7.0?
6)  What is index?
7)  What is KPIs (Key Performance Indicators)?
8)  What is the use of process chain?
9)  Difference between Display Attribute and Navigational Attribute?
10) If there are duplicate data in Cubes, how would you fix it?
11) What are the differences between ODS and Info Cube?
12) What is the use of change log table?
13) Difference between InfoSet and Multiprovider
14) What is the T.Code for Data Archival and what is it’s advantage?
15) What are the Data Loading Tuning from R/3 to BW, FF to BW? 
16) Performance monitoring and analysis tools in BW 
17) Difference between Transfer Rules and Update Rules
18) What is OSS?
19) How to transport BW object?
20) How to unlock objects in Transport Organizer?
21) What is InfoPackage Group?
22) Differences Between Infopackage Groups and Process chains
23) What is Conversion Routine?
24) Difference between Start Routine and Conversion Routine
25) What is the use of setup tables in LO extraction?
26) R/3 to ODS delta update is good but ODS to Cube delta is broken. How to fix it?
27) What is short dump and how to rectify?
28) When we collapse an infocube, is the consolidated data stored in the same infocube or is it stored in the new infocube?
29) What is the effect of aggregation on the performance? Are there any negative effects on the performance?
30) What happens when you load transaction data without loading master data?
31) When given a choice between a single infocube and multiple InfoCubes with a multiprovider, what factors does one need to consider before making a decision?
32) How many hierarchy levels can be created for a characteristic info object?
33) What is open hub service?
34) What is the function of 'reconstruction' tab in an infocube?
35) What are secondary indexes with respect to InfoCubes?
36) What is DB connect and where is it used?
37) Can we extract hierarchies from R/3 for CO-PA?
38) Explain ‘field name for partitioning’ in CO-PA
39) What is V3 update method ?
40) What are the three ODS Objects table explain?
41) What is the common method of finding the tables used in any R/3 extraction
42) Differences between table view and infoset query
43) How to load data from one InfoCube to another InfoCube ?
44) What is the significance of setup tables in LO extractions ?
45) Difference between extract structure and datasource
46) Where is 0RECORDMODE infoobject used?
47) What is referential integrity mechanism ?
48) Other than BW, what are the other ETL tools used for SAP R/3 in industry?
49) What is the importance of hierarchies?
50) What is D-Management in LO ?
51) What is entity relationship model in data modeling ?
52) What is operating concern in CO-PA?
53) Does all the characteristics present in ODS, are key fields.
54) What is the use BAPI, ALE?
55) What is the importance of ‘Compounding’ of infoobjects?
56) What is field partitioning in CO-PA?
57) What is datamining concept ?
58) What are the advantages of reporting on an infocube to that of reporting on an ODS?
59) Usage of Geo-coordinates ?
60) What are the different query areas related to Infoset ?
61) How does the time dependency works for BW objects ?
62) What is I_ISOURCE?
63) What is I_T_FIELDS?
64) What is C_T_DATA?
65) What is I_UPDMODE?
66) What is I_T_SELECT?
67) What is Serialized V3 Update?
68) What is Direct Delta?
69) What is Queued Delta?
70) What is Unserialized V3 Update?
71) What are the different Update Modes?
72) What are the different ways Data Transfer?
73) What is the major importance for the usage of ODS Object?
74) What is the benefit of using BW reporting over SAP Reporting?
75) Differences between star and extended star schema ?
76) What is time dependent master data?
77) What is difference between ‘saving’ and ‘activating’?
78) What are the major errors in BW and R3 pertaining to BW?
79) When are tables created in BW?
80) What is a start routine and return table, how do they synchronize with each other?
81) What is the difference between start routine and update routine, when, how and why are they called?
82) Aggregates are recommended in the following cases,
83) In a general project, how many InfoCubes, InfoObjects, InfoSources, Multi-Providers can you expect?
84) What does a M table signify?
85) What does a F table signify?
86) What is data warehousing?
87) What is process chain and how you used it?
88) What are Remotecubes and how you accessed and used it in your project?
89) Hope you have worked on enhancements and on which userexit you worked can you explain?
90) What is the t-code for generic extractor?
91) What is infoset query?
92) What is the purpose of aggregates?
93) How you did Datamodeling in your project? Explain
94) As you said you have worked on Cubes and ODS,Which one is better suited for reporting? 
95) What are the different cubes you worked in FI?
96) What is delta upload? What is the use of delta upload? Data that has been changed or added is extractor or full data is extractor?
97) What are hierarchies? Explain how you used in your project?
98) What is t-code for CO-PA?
99) What is SID? what is the impact in using SID?
100) What is Table partitioning? What are Return Tables?

0 comments: