Data Integration Hub
- Data Integration Hub 10.5
- All Products
Field
| Description
|
---|---|
DIH__PUBLICATION_INSTANCE_ID
| Required. Identifiers of one or more published data sets in a comma-separated list. Each data set that an application publishes has a unique identifier. To filter the data to consume, use the value from the
$$<topicName>__PublicationInstanceIDs workflow parameter.
The parameter datatype must be number(19) if you write to an Oracle database target or number(19,0) if you write to a Microsoft SQL Server database target.
|
DIH__PUBLICATION_INSTANCE_DATE
| Date and time that each application started publishing the data sets, in a comma-separated list. If you use database partitions, you can filter the data to consume by using the value from the
$$<topic_name>__PublicationInstanceDatesSQL workflow parameter. The value format depends on the publication repository database type.
On an Oracle database, the datatype must be date and the value must be in the following format:
On a Microsoft SQL Server database, the datatype must be datetime and the value must be in the following format:
If you want to filter the data to consume with a different transformation, you can use the
$$<topic_name>__PublicationInstanceDates parameter instead.
|
MY_TABLE.DIH__PUBLICATION_INSTANCE_ID in ($$myTopic__PublicationInstanceIDs) AND MY_TABLE.DIH__PUBLICATION_INSTANCE_DATE in ($$myTopic__PublicationInstanceDatesSQL)