Article Categories
- All Categories
-
Data Structure
-
Networking
-
RDBMS
-
Operating System
-
Java
-
MS Excel
-
iOS
-
HTML
-
CSS
-
Android
-
Python
-
C Programming
-
C++
-
C#
-
MongoDB
-
MySQL
-
Javascript
-
PHP
SAP HANA Articles
Page 50 of 58
Different Engine types in SAP HANA
In SAP HANA, following engine types are available:Join Engine: This is used for attribute viewsOLAP engine: This is used for analytic viewsCalculation Engine: This is used for calculation views
Read MoreDisadvantages of using row based tables in SAP HANA
Row based tables are used when only one record has to be processed at a time. Row based table doesn’t support aggregations and fast searching.When your application needs to access a complete record or a complete row it is recommended to use row based tables.
Read MoreUsing aggregated in SAP HANA
SAP HANA is an in-memory database so all data resides in memory all the time and hence all calculations and functions can happen directly and hence materialized aggregations are not required in SAP HANA database.With the use of column store, data is available vertically and hence operations on different columns can be easily performed.
Read MoreEnabling XS Engine service in SAP HANA Studio
To Configure DXC, you need to enable XS Engine (SAP HANA Extended Application Services). To enable XS Engine Change the Instance value to “1”. XS Engine Service in SAP HANA Studio is used to handle Control Flow Logic.
Read MoreChecking XS Engine service in SAP HANA system
You can try accessing XS Engine using below address in IE.http://:80 and you will get below screen to show that XS Engine is working fine.
Read MoreTable mapping while data replication from flat file in SAP HANA database
Table mapping is last step while uploading data using an Import option in HANA Studio. This shows the data that already exist in the table and also shows the information about the schema and table to which we are going to load the data.Click on Finish to load the data.
Read MoreUsing header rows during flat file upload in SAP HANA
This can be done using File import option. While importing first file, you have an option to “Add columns” in new table so you can create addition columns as per column names in other CSV’s. You can also define their datatypes, length, Primary key, not null and other column properties in same window.
Read MoreImporting limited number of rows from CSV in SAP HANA
Yes, this can be done using File Import option in HANA Studio. In Import data from local file wizard, un-check the option- Import all data and you can mention Start Line and End Line value.
Read MoreMaintaining vendor ID for Delivery unit in HANA using SAP HANA Studio
You can also maintain Vendor ID in Administration tab in SAP HANA Studio. Select HANA system and click on Administration and go to Configuration tab. In filter, enter Vendor and search:Click on Change and you will get an option to enter new Vendor Id value. Click on Save to save the changes.
Read MoreNaming convention for creating a delivery unit in SAP HANA
The name of Delivery Unit must contain only capital letters (A-Z), digits (0-9) and underscores (_). It won’t accept any special characters.
Read More