Ask Sippy

How to give your best shot at any technical interview ? 1. Prepare all the topics that can be asked in interview. 2. Prepare a good CV. 3. Give Example Give example of every answer you give (with diagram if possible). This will show your confidence in that topic. Example must be simple, clear and to the point. 4. Be example ready( Most Important) You need to be ready with example of each topic or question being asked. For this, while preparing for the interview you should have decided the example of each topic. Thinking about example on the spot may take you and interviewer into confusion and may leave bad impression about non clarity of topic. 5. Listen to question of interviewer carefully and attentively. Take your time to analyse the question and arrive at answer. This shows your ability to listen, analyse and solve the problem. 6. If you don't know the answer then politely say that I am not sure about this and will have to check. Do not try to guess and give wr...

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