About the File Update Utility - trillium_discovery - trillium_quality - Latest

Trillium Control Center

Product type
Software
Portfolio
Verify
Product family
Trillium
Product
Trillium > Trillium Discovery
Version
Latest
Language
English
Product name
Trillium Quality and Discovery
Title
Trillium Control Center
Copyright
2024
First publish date
2008
Last updated
2024-10-18
Published on
2024-10-18T15:02:04.502478

The File Update utility updates one file, called the master file (Master), with the data contained in another file, called the transaction file (Tran).

The update is based on the results of comparing the you specify. If the match key values are equal between the master and transaction files, a row is considered to be "matched." If the match key values are not equal, the row is considered to be "unmatched."

Based on the results of the comparison, the File Update utility:

  • Separates the rows in the transaction and master files into multiple output files for review or processing. (See Outputs for a description of the output files.)
  • For matched rows, identifies common attributes and overwrites the master file values with the values in the transaction file.
  • For matched rows, adds attributes that appear only in the transaction file to the master file.
Note: If you do not want to update the common attribute in the master file with the transaction file's value, redefine the attribute name for either the master or for the transaction file.
Note: The File Update utility is designed for batch only and cannot be deployed in a real-time environment. If a real-time project includes the File Update process, the process will be excluded when the project is deployed for use in real time.