Question.1 What is proposed from statistics for aggregates? Answer: You can ask the system to get the optimal characteristics for aggregation by using the BW statistics data (like query run time, etc). Question.2 Can you define aggregates on time dependent navigational attributes? Answer: Yes, as of version 3.x Question.3 What..
Question.1 What is the performance on SAP HANA One as compared to SAP HANA on-premise? Answer: For a similar number and type of CPU cores, memory and I/O configuration, SAP HANA One is comparable to SAP HANA on-premise. Your actual performance will vary based on the nature of workload. Question.2..
Question.1 What is $ as an authorization value? Answer: You use $ followed by a variable name (values populated in user exit for bex); this avoids having too many roles. Question.2 What is info object 0TCTAUTHH? Answer: This is used in hierarchy authorization Question.3 How would you debug security issues?..
Question.1 What is a filter? Answer: A filter, as the name suggests, is used to apply a condition to get specific or “filtered” data in the report. A filter can be applied either at the universe level or at the report level. Filter at the report, the level is nothing..
Question.1 What is SAP HANA One? Answer: SAP HANA One is a single HANA instance hosted on Amazon Web Services. Customers and Partners can use SAP HANA One to provision a secured instance of SAP HANA database. This instance can be used to build and deploy on-demand applications that leverage..
Question.1 What is a data source and an info source? Answer: Data source: The source that is sending data to a particular info source on BW; for example we have a OCUSTOMER_ATTR data source to supp attributes to ©CUSTOMER from R/3. Info source: Group of logically related objects; for example the..
Question.1 What is the role of surrogate keys in the data warehouse and how will you generate them? Answer: A surrogate key is a simple Primary key which maps one to one with a Natural compound Primary key. The reason for using them is to alleviate the need for the..
Question.1 What phases are involved in testing an application in QTP? Answer: The Quick Test Professional process consists of the following main phases: Analyzing Application: before preparing test cases need to analyze the application to find out the testing needs. Preparing Testing Infrastructure: based on testing needs create those resources,..
Question.1 Can you prevent a class from overriding? Answer: Yes, you can prevent a class from overriding. In C#: You can prevent a class from overriding by using the sealed keyword. In Visual Basic: is You can prevent a class from overriding by using the Not inheritable keyword. Question.2 What..
Question.1 Can you use mapping without source qualifier? Answer: Not possible, If source RDEMS/DBMS/Flat file use SQ or use normalizer if the source cobol feed. Question 2.When do you use a normalizer? Answer: Normalized can be used in Relational to denormilize data. [sociallocker] Question.3 What are stored procedure transformations. Purpose..