Posts

Showing posts with the label SAP HANA

Featured Post

SQL Interview Success: Unlocking the Top 5 Frequently Asked Queries

Image
 Here are the five top commonly asked SQL queries in the interviews. These you can expect in Data Analyst, or, Data Engineer interviews. Top SQL Queries for Interviews 01. Joins The commonly asked question pertains to providing two tables, determining the number of rows that will return on various join types, and the resultant. Table1 -------- id ---- 1 1 2 3 Table2 -------- id ---- 1 3 1 NULL Output ------- Inner join --------------- 5 rows will return The result will be: =============== 1  1 1   1 1   1 1    1 3    3 02. Substring and Concat Here, we need to write an SQL query to make the upper case of the first letter and the small case of the remaining letter. Table1 ------ ename ===== raJu venKat kRIshna Solution: ========== SELECT CONCAT(UPPER(SUBSTRING(name, 1, 1)), LOWER(SUBSTRING(name, 2))) AS capitalized_name FROM Table1; 03. Case statement SQL Query ========= SELECT Code1, Code2,      CASE         WHEN Code1 = 'A' AND Code2 = 'AA' THEN "A" | "A

Tutorial: SAP HANA Basics for Beginners

What is SAP HANA? HANA stands for High-Performance Analytic Appliance. SAP HANA is a combination of hardware and software, and is therefore an appliance. SAP HANA supports column- and row-level storage. We can store and perform analytics on a huge amount of real-time, non-aggregated transactional data. Hence, HANA acts as both a database and a warehousing tool, which helps in making decisions at the right time. Challenges in Traditional RDBMS? There are a few challenges in traditional databases, such as latency, the cost involved, and complexity in accessing databases. Related: SAP HANA jobs and career options What is Architecture of traditional RDBMS? Presentation Layer: This is the top-most layer and allows users to manipulate data so that they can input it for querying. This data input from users is passed on to the database layer through the application layer and the results are passed back to the application layer to implement business logics. The presentation layer

Top SAP HANA Iot must read Interview Questions(3 of 3)

The below is my third set of interview questions. In this lot I have given ten interview questions for your quick reference. What is SAP HANA? SAP deployed SAP HANA as an integrated solution that combines software and hardware, which is frequently referred to as the SAP HANA appliance. As with SAP NetWeaver Business Warehouse Accelerator (SAP NetWeaver BW Accelerator), SAP partners with several hardware vendors to provide the infrastructure that is needed to run the SAP HANA software. Lenovo partnered with SAP to provide an integrated solution. 2) What is memory for CORE ratio in SAP HANA? For in-memory computing appliances, such as SAP HANA, the amount of main memory is important. In-memory computing brings data that is kept on disk into main memory. This action allows for much faster processing of the data because the CPU cores do not have to wait until the data is loaded from disk to memory, which means each CPU is better used. SQLDBC:An SAP native database SDK that ca

SAP HANA: Top Data Processing Interview Questions

1. How parallel processing is achieved in SAP HANA? The phrase "divide and conquer" (derived from the Latin saying divide et impera) typically is used when a large problem is divided into a number of smaller, easier-to-solve problems. Regarding performance, processing huge amounts of data is a problem that can be solved by splitting the data into smaller chunks of data, which can be processed in parallel. 2.How data portioning will happen in SAP HANA? Although servers that are available today can hold terabytes of data in memory and provide up to eight processors per server with up to 10 cores per processor, the amount of data that is stored in an in-memory database or the computing power that is needed to process such quantities of data might exceed the capacity of a single server. To accommodate the memory and computing power requirements that go beyond the limits of a single server, data can be divided into subsets and placed across a cluster of servers, which forms a d

SAP HANA In-memory Real Usage

Below are the list of questions on SAP HANA In-memory. That explains the real usage. 1. What is in-memory computing? A1) In-memory computing is a technology that allows the processing of massive quantities of data in main memory to provide immediate results from analysis and transaction.  The data that is processed is ideally real-time data (that is, data that is available for processing or analysis immediately after it is created). 2. How in-memory computing works ? A2) Keep data in main memory to speed up data access. Minimize data movement by using the columnar storage concept, compression, and performing calculations at the database level.  Divide and conquer. Use the multi-core architecture of modern processors and multi-processor servers (or even scale out into a distributed landscape) to grow beyond what can be supplied by a single server. 3. What is the benefit of keeping data in memory? A3) Data accessing from main memory is much faster than accessing data from Disk. 4.

6 Top SAP HANA Blogs Useful for Interviews

The following are the best SAP HANA interview questions: SAP Hana interview questions SAP HANA replication techniques 20 SAP HANA interview questions Advanced SAP HANA Interview Questions 100 SAPA HANA interview questions Interview Questions

Maximizing Your SAP HANA Skills: Top 5 Course Contents to Consider

You can find SAP HANA course contents for your quick reference. You can download as a pdf. Before you take a course these are the contents you need to learn. Module#1. SAP HANA Introduction and Architecture SAP HANA Overview  SAP In-Memory Computing Overview  SAP HANA Features  Look and feel of SAP HANA  SAP HANA Architecture  SAP HANA Landscape  Structure of SAP in-memory Computing studio  Row store and column store Architecture  Multi Version Currency Control(MVCC)  Persistence Layer in In-memory Computing Engine  Back up &Recovery  High-Availability  Distributed System  Data Provisioning options in SAP HANA  Reporting options on SAP HANA  Security options in HANA  SAP HANA Appliance Model  How SAP HANA Appliance is delivered  Sizing Considerations  SAP HANA –Licensing Options  SAP HANA Project Implementation  Overview: Key Activities  Key Roles  Key Points to keep in mind  Administration Module#2. Basic Modeling Modeling Overview Terminology SAP HANA Studio Features Information

SAP HANA top Career Options to Find in Job Market

SAP HANA converges database and application platform capabilities in-memory to transform transactions, analytics, text analysis, predictive and spatial processing so businesses can operate in real-time. I have listed the areas on available careers for SAP HANA. SAP HANA  It has completely transformed the database industry by combining database, data processing, and application platform capabilities in a single in-memory platform. The platform also provides libraries for predictive, planning, text processing, spatial, and business analytics -- all on the same architecture. This makes it possible for applications and analytics to be rethought without information processing latency, and sense-and-response solutions can work on massive quantities of real-time data for immediate answers without building pre-aggregates. Simply put -- this makes SAP HANA the platform for building and deploying next-generation, real-time applications and analytics Operational Analytics With tr

SAP HANA Top new Applications

Image
The SAP HANA analytics from German software vendor SAP AG is betting heavily on a new generation of analytic computing it calls HANA.  In this post you will know the new features that are added in HANA. To maintain its position as the world's largest business-application vendor. So, learning HANA is really good and make sure these HANA course contents you need to have in your training. SAP HANA Applications HANA, which is already installed at more than 200 customer locations, processes data in real-time by storing it in live memory rather than in a separate data warehouse, enabling customers to make business decisions faster. >> Liquor distributor Charmer Sunbelt Group finished installing a HANA system , and it says it has helped managers react to logistical problems as they occur. Getting shipments out is essential for Charmer because customers can refuse them if they are late. >> According to Chief Information Officer Paul Fipps, HANA h