Target transformation mapping example for Import and Load Data object
Target transformation mapping example for Import and Load Data object
You can use a pre-configured DAT file in zip format to directly upload HDL files to Oracle Cloud. Create a flat file and specify the details of the HDL ZIP file path and the business object name. To upload the HDL files to Oracle Cloud, select the Import and Load data object for the write operation.
Pre-requisites:
Before you begin, create a flat file and specify the details of the
HDLZipFilePath
and the
BusinessObjectName
. The sample file shows the configured details in the flat file:
The
HDLZipFilePath
specifies the path to the zip file that encloses the DAT file and
BusinessObjectName
specifies the name of the Oracle HCM target object.
In
Data Integration
, click
New
Mapping
Create
.
The
New Mapping
dialog box appears.
Enter a name and description for the mapping.
In the Source transformation, specify a name and description in the general properties.
In the Connection field, select the flat file connection to connect to the configured flat file that contains the DAT file details.
In the Target transformation, specify a name and description in the general properties.
Perform the following tasks on the
Target
tab:
In the
Connection
field, select the Oracle HCM Cloud V1 connection to connect to Oracle HCM Cloud application.
In the
Operation
field, select the
Import and Load data
object in the
Package Explorer
section.
The following image shows the list of the write operations:
On the
Field Mapping
tab, map the source fields to the target fields.
The following image shows all the mapped fields between the input file and the Oracle HCM Cloud V1 target:
Click
Save and Run
the mapping.
In
Data Integration
, click
New
Task
.
Click
Mapping Task
Create
and select the mapping for the task.
In
Monitor
, you can monitor the status of the logs after you run the task.