Interview Questions.

Question 1. What Is The Relation Between The Number Of Data Transfer Jobs In The Configuration Settings And The Available Bgd Work Processes?

Answer :

Each job occupies 1 BGD paintings procedures in SLT replication server. For every configuration, the parameter Data Transfer Jobs restricts the most wide variety of records load task for every mass transfer ID (MT_ID).

A mass switch ID calls for at least 4 history jobs to be available:

One grasp process

One master controller activity

At least one records load activity

One additional task either for migration/get admission to plan calculation/to trade configuration settings in "Configuration and Monitoring Dashboard".

Question 2. Is It Possible To Specify The Type Of Data Load And Replication In Sap Hana ?

Answer :

Yes it's far feasible to specify type of facts load and replication in SAP HANA, it is able to be either in actual time, or scheduled via time or by c program languageperiod.

Data Warehousing Interview Questions
Question three. What Additional Limitations Does Sybase Replication Server Present?

Answer :

SRS has extra regulations which might be worth to be understood. It best replicates Unicode records and does not help IBM DB2 compress tables.

Question 4. Hana Support In Real-time What Types Of Source Database?

Answer :

If Sybase Replication Server (SRS) for close to real-time records is used then the licensing nevertheless (SAP have license offers pending) wishes to checked. If DB2 is run then its fine however with Oracle and Microsoft SQL Server there are some license demanding situations. So if license is sold through SAP, due to the fact you can have a limited license that doesn't allow extraction

Data Warehousing Tutorial
Question five. Hana Uses Which Storage Subsystem?

Answer :

A shared community attached and varies from dealer to dealer and is called the garage. Here each everyday magnetic disks and SSD storage can be used for the backup of the database (HANA runs in reminiscence recall, so disk garage is only for backup, and later, for statistics ageing). If the operator require 2x garage that you have RAM, that's 2x the database length - i.E. Garage length = 4x database size. Anyways in most cases there may be extra extremely-excessive velocity SSD storage for log documents.

SQL Database Interview Questions
Question 6. How Big Does Hana Scale ?

Answer :

Theory sensible as a minimum very well. Most mid-length workloads - 2TB of in-reminiscence garage is equal to five-20TB of Oracle storage may be run by using the largest unmarried server HANA hardware. HANA works in a way meaning it is viable to chain multiple systems collectively which means that scalability has therefore-a ways been determined by way of the dimensions of customers' wallets. Whilst SAP speak up "Big Data" pretty a lot, HANA currently most effective scales to the small-quit of Big Data relating to the sort of massive datasets that FaceBook or Google need to save - no longer Terabytes, but as a substitute Petabytes.

Question 7. What Is A Private Attribute In Sap Hana?

Answer :

Private attributes are the attributes used interior a modeling views and cannot be used outside the view.These are used in a modeling view to customise the conduct of an attribute for only that view.

SQL Database Tutorial SAP BW Interview Questions
Question eight. What Are Transformation Rules?

Answer :

Transformation rule is a rule targeted in the Advanced Replication settings transaction for supply tables this sort of way that the statistics is converted at some stage in the replication procedure. 

For example: you will specify rule to Convert fields, Fill empty fields and Skip records

Question 9. Define Latency In Sap Hana ?

Answer :

Latency is the length of time to copy statistics (a table entry) from the supply system to the target system.

SAP HANA Interview Questions
Question 10. What Is Advanced Replication Settings?

Answer :

replication settings like modifying goal table systems, specifying overall performance optimization settings that defines transformation guidelines.

SAP BW Tutorial
Question 11. Is There Any Need Of Pre-considered necessary Before Creating The Configuration And Replication?

Answer :

DMIS upload-on is set up in SLT replication server for SAP supply structures. The position IUUC_REPL_CONTENT is assigned to the person for RFC connection but now not DDIC. DMIS add-on is notrequired and grants a database person enough authorization for statistics replication for a non-SAP supply system.

SQL Interview Questions
Question 12. Define Configuration In Slt?

Answer :

The statistics required to create the relationship among the supply device, SLT system, and the SAP HANA gadget is certain within the SLT device as a Configuration. A new configuration in Configuration & Monitoring Dashboard (transaction LTR) can subsequently be described.

Data Warehousing Interview Questions
Question 13. Can We Load And Replicate Data From One Source System To Multiple Target Database Schemas Of Hana System?

Answer :

Yes. It may be loaded and replicated for up to 4 objectives.

SAP HANA Tutorial
Question 14. What Is Slt(sap Landscape Transformation) In Sap Hana?

Answer :

The complete shape of SLT is SAP Landscape Transformation which is not anything however a cause based replication. It is the replication era to skip the facts from the source gadget to the goal system. Here the supply can be both SAP or non-SAP whereas the Target machine is SAP HANA device which includes HANA database.

Question 15. What Is Sap Hana Appliance 1.0?

Answer :

SAP HANA 1.0 is an analytics equipment which consists of licensed hardware, and In Memory DataBase (IMDB), an Analytics Engine and some tooling for buying records inside and out of HANA. The good judgment and structures are constructed with the aid of the user and a tool is used.

Example: SAP BusinessObjects, to visualize or examine records.

SAP Testing Interview Questions
Question 16. What Is Sqlscript In Sap Hana ?

Answer :

It is a fixed of SQL extensions for SAP HANA database which permit builders to push data in depth good judgment into the database.

SAP Testing Tutorial
Question 17. How To Set-up Tracing?

Answer :

From the Administration attitude, navigate to tab “Trace Configuration” . In order to alternate settings, you need to have system privileges “TRACE ADMIN” and “INFILE ADMIN”. 

SAP BW on HANA Interview Questions
Question 18. What Is The Difference Between Break And Continue?

Answer :

Break means loop have to forestall processing, CONTINUE method loop should prevent processing the modern-day generation and without delay start processing the following new release.

SQL Database Interview Questions
Question 19. What Operator Is Used To Debug Sqlscript Procedures?

Answer :

TRACE operator. It lines the tabular statistics surpassed as its argument into a nearby transient desk and return its enter unmodified. The names of the brief tables may be retrieved from the SYS.SQL SCRIPT TRACE view. 

Example: out = TRACE (:enter);

SAP BW on HANA Tutorial
Question 20. When Should Be Sqlscript Used In Sap Hana ?

Answer :

 It need to be utilized in cases where other modeling constructs of HANA inclusive of Attribute views or Analytic views aren't sufficient.

SAP S/4HANA Interview Questions
Question 21. Explain How Sqlscript Procedure Is Processed In Hana Database?

Answer :

When a person creates a brand new manner, the HANA database question compiler first:

Parse the statements
Check the announcement semantic correctness
Optimize the code for Declarative and Imperative good judgment
Code generation creates Calculation models for Declarative common sense and L nodes for Imperative good judgment
Compiled technique creates Content inside the database Catalog and in Repository
Question 22. What Happens When You Compile The Procedure In Sap Hana ?

Answer :

During compilation, the decision to the technique is rewritten for processing by using the calculation engine.