SAP BW HANA Interviews Series

SAP BW HANA Interview Questions (Part 2)

Do checkout this commonly asked SAP BW HANA Interview Q/A Series and prepare for your interviews easily. This is Part 2 of 10 Part Series.

SAP BW HANA Interview Series

1. When do you use START ROUTINE and when do use use END ROUTINE ?

When we execute a DTP, START ROUTINE runs before the execution of the transformation rules. It runs for each data package at the start of the transformation, itself.

START Routine could be used when:

  • We are willing to delete any unwanted records at the beginning itself
  • When sorting of records are required
  • When eliminating or merging of records are required

For END ROUTINE, post the execution of transformation, and just before the value records are being transferred to the output, end routine runs.

Manipulation of target data packages could be done using end routine

END Routine could be used when –

  • We want to delete the records that are not to be updated in the target
  • When lookup is required
  • To calculate key figure values for each records
  • To perform data checks

2. Which table is being generated when a DTP is activated?

A DTIS (Data Transfer Intermediate Storage) is the table which is being generated when a DTP is executed.

DTIS temporary stores the data so that the data can be processed further by the DTP.

DTIS mainly used for Error Handling as when error handling is being activated, the DTIS is the one, which will be used as Error Stack.

3. What is Use of Smart Data Access?

When you want to access the data remotely, which is processed through other systems other than SAP, then we have to create a SDA connection for the same. This remote data is being stored in local tables in SAP HANA.

Using SDA, SAP HANA can create virtual tables which are being mapped to those local tables which are created using the SDA. SAP HANA can access the data directly using the SDA Connections.

Virtual tables can act like any other database tables and can be manipulated accordingly, just like any other table.

4. What are the type of Attributes available in SAP?

  • Display Attribute : Any Info object which is being added to the attribute tab, is known as display attribute and it is completely dependent on the master data (P Table).
  • Navigational Attribute : If you are getting the drill down option while accessing the characteristics in the report, then they are navigational attribute. They always hold present data and no historic data.
  •  Executive Attribute : They are those attributes, where that particular key figure can only be used as attribute for other characteristics but it cannot be used as a dedicated key figure in the infocube itself.
  • Transitive Attribute : A navigational attribute of the navigational attribute.

5. Which T-Code has replaced RSA7 in BH4HANA ?

ODQMON (For monitoring of operational delta queue)

Hope you like the SAP BASIS Interviews Series Part 2.

Check out other parts at my website : https://acorporateguy.com/