BI GENERIC DATA EXTRATION INTERVIEW QUESTIONS&ANSWERS FROM TOP MNCS

   BI GENERIC DATA EXTRATION INTERVIEW  QUESTIONS&ANSWERS

1. How many types of Exactions are there?

ANS: Two types

- Application Specific

- Cross Application

2. What is meant by Extraction?

ANS: Extraction is nothing but loading up of the data from one source system to the other source system.

3. What is the T-CODE for creating GENERIC DATASOURCE?

ANS: RSO2

4. Why do you go for GENERIC DATASOURCE?

ANS: There are mainly two reasons for going GENERIC EXTRACTION.

- When we don’t have any business content data source readily available.

- Even if a business content data source is available, and it is already being used up and if we want to simulated the same kind of data source, we go for generic extraction.

5. How many ways did you create Generic datasource?

ANS: Three ways.

- Transaction data

- Master data

- Texts

6. How many ways did you extract generic data source?

ANS: 4 ways

- Table

- View

- Function Module

- Info set

- Domain (for TEXTS data sources only).

7. What is the difference between creating GENERIC DATASOURCE using VIEW and FUNCTION MODULE?

ANS: In VIEW the EXTRACT STRUCTURE is automatically created, but in FUNCTION MODULE we must created the EXTRACT STRUCTURE explicitly.

8. When do you go for creating VIEW and FUNCTION MODULE?

ANS:  If there is 1:1 relationships then go for creating VIEW and if there is 1:M relationship go for creating FUNCTION MODULE.

9. What is the importance of SELECTION, HIDE, INVERSION and FIELD ONLY check boxes?

ANS:

- SELECTION - > What ever the fields we select here those fields can appear at DATA SELECTION tab of INFOPACKAGE.

- HIDE -> What ever the fields we select here those fields can’t be appear in BW side.

- INVERSION -> This option is available for Key figures. It takes –ve sign to the existing values.

- FIELD ONLY -> This option also available for Key figures. If there is any Enhancement for a particular field at that time this is enabled.

10. Did you create Generic Extraction? If yes tell me the scenario?

ANS: 1. FUNCTION MODULE

To Extract Open deliveries: The data source 2LIS_12_VAITM is available as a part of business content extractor, all the delivery item level information. So to extract only open deliveries we have built generic data source with function module. We used 3conditions to identify an open delivery.

• If delivery is consider to bean open delivery, if it has no PGI (post goods issue) document.

• If delivery is consider to bean open delivery, if it has PGI (post goods issue) documents, and if this PGI document doesn’t contain billing document.

• If delivery is consider to bean open delivery, if it has PGI (post goods issue) documents, and if this PGI documents contain billing document, and this billing document is not yet to be posted.

We have a database table LIPS, which contains all delivery item level information. So we collect all the records from this LIPS table and cross check whether give delivery is open delivery or not. If it is open delivery insert the record into E_T_DATA (internal table).

LIPS – Delivery item level information.

VBFA – sales Document Flow

VBRP – Billing Document Item data.

2. VIEW

In SAP R/3 3.1v there is no business content data source to extract FI_AR information so we went about building the generic data source using the view built on two tables BSID and BSAD.

BSID – Accounting: Secondary index for customers

BSAD - Accounting: Secondary index for customers (cleared items)

Some common fields in these two tables are COMPANY CODE, CUSTOMER NUMBE etc).

11. Why do you go for ALE DELTA? And for which type of data sources we are going for ALE DELTA?

ANS: When we are generating MASTER DATA delta we go for ALE delta. If there is any changes in MASTER DATA those effects can also occurs in BW side.

12. How do you find CHANGE DOC OBJECT field for master data?

ANS: Go to SE11 – Data Dictionary and see the table TCDOB by selecting corresponding table

13. In which T-CODE did you change the data for MATERIAL MASTER DATA?

ANS: MM01 – creation of Material master data

MM02 – Change

MM03 – Display

14. What is the use of GENERIC DELTA? And when do you go for GENERIC DELTA?

ANS: When we are generating TRANSACTION DATA for delta we go for GENERIC delta. If there is any changes in TRANSACTION DATA those effects can also occurs in BW side.

VA01 – Creation of SALES and DISTRIBUTION

VA02 – change

VA03 – Display

15. What are the different ways of setting up the delta in generic extraction for transaction data?

ANS: There are mainly 3 options available for generic delta. Those are

• Calday – if we setup delta on base of calday we can run delta only once per day that to at the end of the clock to minimize the missing of delta records.

• Numeric pointer – This type of delta is suitable only when we are extracting data from a table which supports only creation of new records, but not change of exiting records

• Time stamp – Using timestamp we can run delta multiple times per day but we need to use the safety lower limit and safety upper limit with minimum of 5 minutes.

16. When you setup delta for generic data source, where does data come from?

ANS: RSA7 (DELTA QUEUE)

17. When you are setting up the delta in generic data sources, what are the different images we can setup?

ANS: We can setup 2 types of images,

- New status for changed records

- Additive delta

18. When I am setting up the delta for the generic data source if I select the update method a NEW ATATUS for changed records can I load the data directly to the cube?

ANS: NO. If the update type is setup to NEW STATUS for changed records then it becomes mandatory for us to load data into ODS and then ODS to CUBE.

19. What is the difference between BUSINESS CONTENT DATASOURCES and GENERIC DATA SOURCE?

ANS: In the case of business content data source the data source is ready madely available in delivered version. In order to use it we have to install that particular data source to create a copy of the data source in active version by using RSA5 t-code, select the data source and click on transfer data source. In case of generic data source we are creating our own data sources. We prefer business content data sources with specific to performance.

20. What is DATA SOURCE?

ANS: Data source defined ES and TS at source system and TS at BW system.

21. When does the Transfer structure at SAP R/3 side get generated?

ANS: When you activate transfer rules in BW, it creates a transfer structure at SAP R/3 side.

22. Steps to generate GENERIC EXTRACTION METHOD?

ANS: Go to RSO2 -> selected the type of extractor to extract the data from R/3 to BW- > click on create -> select Application Component based on which type of data we are extracting -> give the name from which we are extracting the data like table/view, function module, info set etc. -> give short, medium, long descriptions and click on save -> select the field here and again click on SAVE-> go to BW side replicate your data source based on the type of application component to which you are extracted.-> Assign transfer rules and activate-> create cube and updated rules -> go to source system and create info package and schedule the info package.