Developer Guide

10.5
- 10.4.1
- 10.4.0

Back Next

Creating the Target Definition

In the PowerCenter Designer, create the target and add ports to store properties for running the workflow. You can also add properties to store other

Data Integration Hub

values that you want to send back from PowerCenter.

The target definition process includes the following steps:

Create the target object.

If you develop a publication workflow, use the DIH__STAGING connection in the target definition. The database target type must match the publication repository database type.

If you develop a publication workflow, add the required fields that determine the data set to publish.

The following table describes the required fields to add to the target object of a publication:

Parameter	Description
DIH__PUBLICATION_INSTANCE_ID	Required. Identifier of the published data set. Each data set that an application publishes has a unique identifier. The field uses the value from the $$publicationInstanceID workflow parameter.
DIH__PUBLICATION_INSTANCE_DATE	Required. Date and time that the application started publishing the data set. The field uses the value from the $$publicationInstanceDate workflow parameter. The value format depends on the publication repository database type. On an Oracle database, the value must be in the following format: to_date('<DATE>', 'YYYY-MM-DD HH24:MI:SS') On a Microsoft SQL Server database, the value must be in the following format: convert(datetime,'<DATE>',120)

Parameter

Description

DIH__PUBLICATION_INSTANCE_ID

Required. Identifier of the published data set. Each data set that an application publishes has a unique identifier. The field uses the value from the $$publicationInstanceID workflow parameter.

DIH__PUBLICATION_INSTANCE_DATE

Required. Date and time that the application started publishing the data set. The field uses the value from the $$publicationInstanceDate workflow parameter. The value format depends on the publication repository database type.

On an Oracle database, the value must be in the following format:

to_date('<DATE>', 'YYYY-MM-DD HH24:MI:SS')

On a Microsoft SQL Server database, the value must be in the following format:

convert(datetime,'<DATE>',120)

Rename Saved Search

Table of Contents

Developer Guide

Developer Guide

Creating the Target Definition

Creating the Target Definition