Posts

Showing posts from June, 2018

How to prepare for SAP BOBJ interview?

Below is the outline for typical SAP BO technical interview prepration. They are top asked topics in junior to senior level positions. 1) "Tell me about yourself" Start with your name, qualification, tools and projects worked. Your current role. 2) RDBMS concepts - Clarity on basic database concepts like primary key, foreign key, Unique key etc. - Different types of joins - Normalization - Set operations like Union, intersection etc. - Aggregation of data - Question on Rank over partition 3) Datawarehousing concepts Some key concepts like datamart, start schema, snow flake schema, slowly changing dimensions etc. 4) Universe Design with UDT and IDT - Difference between UDT and IDT - Fan Trap, Chasm Trap - Loops and ways to solve them - Row level and column level security - Some scenario based questions to check your experience of working with Universe - Aggegate aware - Index Awareness - Shortcut joins 5) Webi Reporting - Challenges you faced while ...