Found 694 Articles for SAP HANA

Using Delivery unit in SAP HANA

Anil SAP Gupta
Updated on 25-Jun-2020 08:18:31

126 Views

In SAP HANA system, delivery units are used to transport repository objects between different HANA systems and is used by Lifecycle Manager LCM.To create a Delivery unit, you have to navigate to SAP HANA Modeler Perspective → Delivery Unit

Using Delivery unit in SAP HANA

Anil SAP Gupta
Updated on 25-Jun-2020 08:19:15

273 Views

In SAP HANA system, delivery units are used to transport repository objects between different HANA systems and is used by Lifecycle Manager LCM.To create a Delivery unit, you have to navigate to SAP HANA Modeler Perspective → Delivery Unit

Moving objects from one package to another package in SAP HANA

Anil SAP Gupta
Updated on 30-Jul-2019 22:30:22

602 Views

In SAP HANA Modeler perspective, you have an option of “Mass Copy” using which you can copy mass objects from package to other package. You have to define source and target package mapping.To add new package mapping, you can use button and select Source and Target package from drop down list. In next window, you have to select models and click on Next.

Importing limited number of rows from CSV in SAP HANA

Anil SAP Gupta
Updated on 30-Jul-2019 22:30:22

206 Views

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.

Using header rows during flat file upload in SAP HANA

Anil SAP Gupta
Updated on 30-Jul-2019 22:30:22

182 Views

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.

Different mapping options in SAP HANA while importing data from flat file

Anil SAP Gupta
Updated on 25-Jun-2020 08:17:37

167 Views

In SAP HANA, using file import you can load data to an existing table or can create a new table with the same column names as in the flat file.While using import wizard, you can define the mapping of columns. Following options are available −One to OneMap by NameUsing Map by Name option, you can map columns in CSV files to the columns in an existing table.

Table type while importing data from flat file in SAP HANA

Anil SAP Gupta
Updated on 30-Jul-2019 22:30:22

146 Views

While importing data using flat file, you can use any existing table or can also create a new table in any of schema in database.You can create a new table in any of existing schema and also define table type in next window.Under target table, you can mention if you want to use an existing table or  create a new table. Select Schema name from drop down list and enter the table name. Once you click on Next button, in next window you can select table type.

Trigger based SAP HANA data replication

Anil SAP Gupta
Updated on 25-Jun-2020 08:16:41

318 Views

In SAP HANA data replication, following replication methods can be used −SAP Landscape Transformation (SLT)SAP Data ServicesDXCFrom the above method, SAP Landscape Transformation (SLT) Replication is a trigger based data replication method in HANA system. It is used for replicating real-time data or schedule-based replication from SAP and non-SAP sources. It has SAP LT Replication server, which takes care of all trigger requests. The replication server can be installed as a standalone server or can run on any SAP system with SAP NW 7.02 or above.To use this method, you have to navigate to Data Provisioning under SAP HANA Modeler ... Read More

Table mapping while data replication from flat file in SAP HANA database

Anil SAP Gupta
Updated on 30-Jul-2019 22:30:22

126 Views

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.

Using flat file load in SAP HANA database

Anil SAP Gupta
Updated on 30-Jul-2019 22:30:22

318 Views

You can use Import.. option in SAP HANA Studio to import data from a CSV file. Go to file and click on Import option.Next is to define Import properties. You can create a new table or you can also use an existing table in HANA database. You can also define if a Header rows exists.

Previous 1 ... 7 8 9 10 11 ... 70 Next
Advertisements