Sorting data when writing a flat File
When writing an flat file, data can be sorted with the use of sort keys.
This offers the possibility to order easily the data that is written in the flat file with, if needed, multiple sort keys.
Stambia versions 2.x, 3.x, S17, S18, S19 and S20 are reaching End of Support January, 15th, 2024. Please consider upgrading to the supported Semarchy xDI versions. See Global Policy Support and the Semarchy Documentation.
The Stambia User Community is moving to Semarchy! All the applicable resources have already been moved or are currently being moved to their new location. Read more…
When writing an flat file, data can be sorted with the use of sort keys.
This offers the possibility to order easily the data that is written in the flat file with, if needed, multiple sort keys.
Stambia Data Integration allows to work with Flat files to produce fully customized Integration Processes.
The fields of DELIMITED or POSITIONAL files can be reversed in Metadata and then used in Mappings and Processes to design and adapt the business rules to meet the user's requirements.
An interesting feature of the Stambia file driver is the possibility in Mappings or Processes to use the properties of a file, such as the file size, path, name or binary content, ...
This article summarizes all the available properties that can be used, and how with Mapping and Process examples.
The Stambia File Driver has a powerfull functionality allowing to read data from multiple files.
This permits to load data from a set of files having the same structure.
When working with files in Stambia, there might be a need to name them dynamically, depending on parameters, time, ...
This article shows some ways to accomplish that.