Best SAP BW Interview Questions and Answers for 1 Year Experienced

Q1. SOME DATA IS UPLOADED TWICE INTO INFOCUBE. HOW TO CORRECT IT?

Ans: But how is it possible?.If you load it manually twice, then you can delete it by request.

Q2. CAN U ADD A NEW FIELD AT THE ODS LEVEL? 

Sure you can.ODS is nothing but a table.

Q3. CAN NUMBER OF DATASOURCE HAS ONE INFOSOURCE

Yes of course.For example, for loading text and hierarchies we use different data sources but the same infosource.

Q4. BRIEF THE DATAFLOW IN BW. 

Data flows from transactional system to analytical system(BW).DS on the transactional system needs to be replicated on BW side and attached to infosource and update rules respectively.

Q5. CURRENCY CONVERSIONS CAN BE WRITTEN IN UPDATE RULES. WHY NOT IN TRANSFER RULES? 

Q6. WHAT IS PROCEDURE TO UPDATE DATA INTO DATA TARGETS?

Full and delta.

Q7. AS WE USE Sbwnn,SBiw1,sbiw2 for delta update in LIS THEN WHAT IS THE PROCEDURE IN LO-COCKPIT? 

No lis in lo cockpit.We will have data sources and can be maintained(append fields).Refer white paper on LO-Cokpit extractions.

Q8. SIGNIFICANCE OF ODS. 

It holds granular data.

Q9. WHERE ARE THE PSA DATA IS STORED? 

In PSA table.

Q10.WHAT IS DATA SIZE?

The volume of data one data target holds(in no.of records)