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

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 distributed database.

The individual database tables can be placed on different servers within the cluster. Tables bigger than what a single server can hold can be split into several partitions horizontally (a group of rows per partition) or vertically (a group of columns per partition), with each partition on a separate server within the cluster.

3. What are key features in SAP HANA?

SAP HANA database- The SAP HANA database (which is also referred to as the SAP in-memory database) is a hybrid in-memory database that combines row-based, column-based, and object-based database technology that is optimized to use the parallel processing capabilities of current hardware. It is the heart of SAP offerings, such as SAP HANA.

SAP HANA appliance (SAP HANA) -SAP HANA is a flexible, data source-neutral appliance with which you can analyze large volumes of data in real time without needing to materialize aggregations. It is a combination of hardware and software and is delivered as an optimized appliance with SAP's hardware partners for SAP HANA.

4. Basics of SAP HANA internet of things?


5) What is SAP HANA internet of things?

The customers of discrete manufacturing companies are more and more demanding. They expect individualized solutions with a combination of products and services. To understand their customers’ unique requirements, companies have to capture and analyze real-time data from products through embedded software. Manufacturers are responding with cloud-based platforms. With output and throughput relevant across the entire product and customer life cycles, manufacturers can serve customers in new and more cost-efficient ways, expanding their business opportunities.

6) Case Studies of SAP HANA internet of things?

Many SAP customers are transforming business models with IoT. Let me give you three examples. Using the SAP HANA Cloud Platform and supply chain management solutions including production planning and shop floor management, Harley Davidson increased output by 25 percent by creating an end-to-end connected manufacturing operation from customers to shop floor. Delighted customers can now configure a customized motorcycle up to six hours before final production versus the previous time of 21 days.(ref:SAP)

Another example is how Kaeser transformed its business model. Instead of compressors, Kaeser now sells cubic meters of compressed air through their “Sigma Air Utility” service. Sensors on its compressors at customer sites capture and transmit real-time air metering and quality data for faster error resolution, minimizing downtime. Kaeser is working with SAP on a predictive maintenance solution for its equipment.(ref:SAP)

A third example is GEA, one of the world’s largest suppliers for the food processing industry. GEA is using SAP Predictive Maintenance & Service and SAP IoT connector on the HANA Cloud Platform to help remote technicians monitor machine performance in real-time, identifying and solving problems faster while reducing downtime and increasing product quality.(ref:SAP)

7) What is the motto for IOT?

When processing power is so cheap, you can afford to put processors in places that you couldn't before—not just a business workstation or a home PC but also a telephone, an electricity meter, a bedside lamp, or a teddy bear. We can make objects intelligent. We can make them think and speak. Pundits have dubbed this "physical computing", "ubiquitous computing" or "ubicomp", or "the Internet of Things". Whatever you choose to call it.

8) What is basic architecture in IOT?

Watch Video here.

Related:

Comments

Popular posts from this blog

How to Fix datetime Import Error in Python Quickly

Explained Ideal Structure of Python Class

How to Check Kafka Available Brokers