Table of Contents

Search

  1. Preface
  2. Installing Informatica MDM - Relate 360
  3. Configuring Relate 360
  4. Configuring Security
  5. Setting Up the Environment to Process Streaming Data
  6. Configuring Distributed Search
  7. Packaging and Deploying the RESTful Web Services
  8. Troubleshooting

Installation and Configuration Guide

Installation and Configuration Guide

LATEST_TIMESTAMP

LATEST_TIMESTAMP

The LATEST_TIMESTAMP rule selects the row that contains the most recent value in a time stamp column as the preferred record. To identify a preferred column value, the LATEST_TIMESTAMP rule selects the corresponding column value in the preferred record as the preferred column value.
The time stamp column must contain values in the
yyyyMMddHHmmss
format. If you do not specify a time stamp column for the rule, the consolidation process selects the row with the most recent time stamp in the repository or skips the rule if you persist the consolidated data in HDFS.
The following table displays a sample cluster and indicates the preferred record for the cluster based on the LATEST_TIMESTAMP rule:
Cluster ID
Employee Name
City
Date&Time
Department
Comment
1
John Smith
New York
20140923114923
Sales
Row-level preferred record
1
J Smith
20131020094712
Human Resources
1
John Jr Smith
Seattle
20120130123446
Support
The LATEST_TIMESTAMP rule selects the first row as the preferred record because it contains the most recent time stamp value.
Use the following format to configure a LATEST_TIMESTAMP rule:
<DefaultRule name="<Rule name>" rule="LATEST_TIMESTAMP" order="<Execution order>"> <ReferenceColumn columnName="<Time stamp column name>" /> </DefaultRule>
The format uses the following parameters:
Rule name
Unique name for the rule.
Execution order
Optional. Order of execution for the rule. Use an integer value for the order of execution. If you do not specify the execution order, the consolidation process runs the rule based on the sequence of rules listed in the consolidation rules file. If you specify the execution order for a rule, you must specify the execution order for other rules.
Time stamp column name
Optional. Name of the time stamp column that contains values in the
yyyyMMddHHmmss
format. By default, the consolidation process uses the time stamp of the record in the repository.
The following sample LATEST_TIMESTAMP rule uses the Date&Time column to identify the preferred record:
<DefaultRule name="defaultRule1" rule="LATEST_TIMESTAMP" order="1"> <ReferenceColumn columnName="Date&Time" /> </DefaultRule>

0 COMMENTS

We’d like to hear from you!