Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
In SAP HANA, following permanent license type is supported −Unenforced License: When you use an unenforced license key in SAP HANA and consumption of HANA system exceeds the license amount of memory, it doesn’t effect the operation of SAP HANA database.Enforced License: When an Enforced license key is installed and consumption of HANA system exceeds the license amount of memory, HANA system gets locked. If this situation occurs, HANA system has to be restarted or a new license key should be requested and installed.
SAP S/4 HANA is based on installation options which are provided by HANA and it includes on premise deployment, cloud based deployment or Hybrid deployment model.Following are the advantages of using SAP S/4 HANA −Multi tenancySAP S/4 HANA takes advantages of HANA's multi tenancy feature, with this option we can run ECC and CRM or any other satellite system on one box. A typical ECC - CRM data transfer accounts for 60% of overall system load, with this multi tenancy option this data transfer load will go away.Simplified Data modelsSAP removed the redundant tables required for aggregates and indices. This ... Read More
In this problem, one polygon is given, and a point P is also given. We need to check whether the point is inside the polygon or outside the polygon.For solving it we will draw a straight line from the point P. It extends to the infinity. The line is horizontal, or it is parallel to the x-axis.From that line, we will count how many times the line intersects the sides of a polygon. When the point is inside the polygon, it will intersect the sides, an odd number of times, if P is placed on any side of the polygon, ... Read More
A number is said to be a perfect square number if the square root of that number is an integer. In other words, when a square root is a whole number, then the number is called a perfect square number.We can check perfect square by finding the square root of that number and match with i again and again to get exact square root. When the square root crosses the value, it is not a perfect square number.But here to reduce effort, we have not checked the square root again and again. As we know that the square root of ... Read More
In a general scenario, it is advisable to store the table as Column store when you have to run complex OLAP queries. OLAP queries include complex calculations and different SQL aggregation functions are used in the query.Select Sum(Sales) from table_name where Column1=’ABC’; Aggregate Functions include −Sum() - returns the sum of the numeric values in a given columnMax() - returns the maximum of the numeric values in a given columnMin() - returns the minimum of the numeric values in a given columnAverage() - returns the average of the numeric values in a given columnPercent() - returns the percentage of the numeric ... Read More
Two sets are disjoint set when they have no common elements. In other words, if we get the intersection of two sets, then we will get null set.The method is simple, in this algorithm, two sets are given. We assume that both sets are already sorted, items are compared between two sets. when there is a match, then it is not a disjoint set, when no items are matched, they are disjoint sets.Input and OutputInput: Two sets: set1: {15, 12, 36, 21, 14} set2: {7, 89, 56, 32} Output: Both sets are disjointAlgorithmisDisjoint(set1, set2)Input: Two sets.Output: True when both sets ... Read More
To request a license key from SAP Marketplace, you require an S-ID and the “Request License Key” authorization for the installation number or customer number you require. To request your license key, you need to open SAP Service Marketplace −https://support.sap.com/en/my-support/keys.htmlNext is to launch license key application → It will prompt to enter SID and password again. Enter the credentials and you will reach to this page −To get license key from SAP Marketplace, you may need the following information −Provide the System IDProduct typeProduct VersionHostname of ServerSystem Usage TypeOperating System TypeTo proceed to the hardware data, choose “Continue”.Enter your hardware ... Read More
Three points of a triangle are given; another point P is also given to check whether the point P is inside the triangle or not.To solve the problem, let consider the points of the triangle are A, B, and C. When the area of triangle Δ𝐴𝐵𝐶 = Δ𝐴𝐵𝑃 + Δ𝑃𝐵𝐶 + Δ𝐴𝑃𝐶, then the point P is inside the triangle.Input and OutputInput: Points of the triangle {(0, 0), (20, 0), (10, 30)} and point p (10, 15) to check. Output: Point is inside the triangle.AlgorithmisInside(p1, p2, p3, p)Input: Three points of a triangle, the point p to check.Output: True, when ... Read More
When you use a Text join in SAP HANA, following condition should be met −You should have Text table always on the right side in joinThere should be a Language columns definedBelow shows an example of Attribute join where Language column is used in text join −
Like other database, you can insert rows in column based table in SAP HANA using Insert statement. Insert statement can be written in SQL editor in HANA.To open SQL editor, you can select HANA system and click on SQL sign at top.Below SQL statements can be used to insert the data −INSERT INTO TEST.PROD_DESC VALUES (11, ’E’, ’Table’); INSERT INTO TEST.PROD_DESC VALUES (11, ’D’, ’Chair’); INSERT INTO TEST.PROD_DESC VALUES (14, ’E’, ’32 LED’); INSERT INTO TEST.PROD_DESC VALUES (14, ’D’, ’32 inch LCD’); INSERT INTO SAP_STUDENT.PRODUCT_DESC VALUES (25, ’E’, ’Comp Table’); INSERT INTO SAP_STUDENT.PRODUCT_DESC VALUES (25, ’E’, ’Mixer’);Read More