Oracle HCM Cloud V1 Target transformation in Mappings
When you configure a Target transformation, select the Oracle HCM Cloud V1 connection and choose an Oracle HCM operation to represent an Oracle HCM Cloud V1 target.
Target Transformation Properties
You can use one or more Target transformations in a mapping.
When you select a target transformation, the Properties panel displays the following sections:
General
Use to configure the name and a description for the target.
Incoming Fields
Includes the field rules that define the data written to the target. Allows a preview of the target fields.
Target
Use to select the connection and the operation, and to configure the advanced target properties.
Target Fields
Not applicable for Oracle HCM Cloud V1 targets.
Field Mapping
Use to define the field mappings from the upstream transformation to the target.
Prerequisite Tasks for Person Number Auto Generation
After you perform the pre-requisite tasks for the Write operation, copy the standard Excel templates and perform the modifications mentioned below.
Perform the following steps to automatically generate the Person Number for Worker objects:
1Change the AttributeName to AttributeName(HintAtrributeName) as required. For example,
- PersonId to PersonId(SourceSystemId)
- JobId to JobId(GUID)
2Change the Attribute data type to HINT Attribute data type. For example, change the data type of the PersonId(SourceSystemId) attribute from Number to String as the Hint Attribute SourceSystemId data type is String.
3Save the Excel template with the modifications and copy it to the Writer folder within the Schema Directory.
Note: To avoid the loss of all modifications, do not connect to the respective Oracle HCM Cloud instance after you modify the standard Excel template.
The following image shows the Field Mapping tab, with the Hint attribute in this format: __HINT__ AtributeName __ HintAttributeName. For Example: __HINT__PersonId__SourceSystemId.
Oracle HCM Cloud V1 Advanced Target Properties in Mappings
In a mapping, you can configure or create a Target transformation and configure the advanced properties in the Target page of the Mapping Task wizard.
The following table describes the advanced properties that you can configure in a Target transformation:
Property
Description
Cache Size for Web Service Request (KB)
Not Applicable.
Note: Do not change the value of this property unless Informatica Global Customer Support instructs you to do so.
Input settings properties
You can enable Sorted Input under Input Settings. Sorted Input indicates that input data is presorted. Default is disabled.
Enable sorted input for better performance.
Note: When Sorted Input is enabled and the input is not sorted, the Secure Agent does not process input and the mapping fails.
Target Transformation Mapping Example
You can map a source to an Oracle HCM Cloud V1 target and use the mapping to perform a mapping task.
To read data from a source and write to an Oracle HCM Cloud V1 target, perform the following tasks:
1In Data Integration, click New > Mapping > Create.
The New Mapping dialog box appears.
2 Enter a name and description for the mapping.
3On the Source transformation, specify a name and description in the general properties.
4On the Target transformation, specify a name and description in the general properties. Perform the following tasks on the Target tab:
aIn the Connection field, select the Oracle HCM Cloud V1 connection to connect to Oracle HCM Cloud application.
bIn the Operation field, select the required object in the Package Explorer section and select the required operation.
The following image shows the list of the write operations:
cIn the Advanced Properties section, set the cache size.
5On the Field Mapping tab, select the input elements to map to the target fields.
The following image shows all the mapped fields between the input file and the Oracle HCM Cloud V1 target:
6Map the source and target.
7Click Save and Run the mapping.
8In Data Integration, click New > Task.
9Click 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.
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:
Note: 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.
1In Data Integration, click New > Mapping > Create.
The New Mapping dialog box appears.
2 Enter a name and description for the mapping.
3In the Source transformation, specify a name and description in the general properties.
4In the Connection field, select the flat file connection to connect to the configured flat file that contains the DAT file details.
5In the Target transformation, specify a name and description in the general properties. Perform the following tasks on the Target tab:
aIn the Connection field, select the Oracle HCM Cloud V1 connection to connect to Oracle HCM Cloud application.
bIn 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:
6On 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:
7Click Save and Run the mapping.
8In Data Integration, click New > Task.
9Click 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.
