Hashed File Stage
Summary
Hashed File stages represent a hashed file which is a sequential file that uses a hashing algorithm to distribute records across one or more groups on disk. The Hashed File Stage can be used to access UniVerse files.
IBM Documentation
Server Stage: Hashed File Stages - IBM Documentation
Parallel Stage: DRS Connector stage - IBM Documentation
Conversion Notes
Key points you should know:
Server Hashed Files stages are converted to Parallel DRS Connector stage (for good reasons), which means that Server jobs which stored their data in Hashed Files will be converted to Parallel jobs which read from / write to the storage mechanisms supported by the DRS Connector (Oracle, DB2 or ODBC)
Hashed files which are loaded or maintained by the S2PX solution are stored in your database using a S2PX-specific format.
Any persistent data you use (i.e. which enables one execution of a job to communicate changes to subsequent executions of a job) which is stored in Hashed Files will need to be loaded in to your DRS-compatible data storage platform
Structural changes
The Hashed File stage can be used to both read and write, sometimes simultaneously within the same job design, which is not a job design supported by the DRS stage. The way these patterns are handled is to create seperate Jobs for the Insert and Read sides of the process, and orchestrate them using an S2PX-generated Job Sequence.
See Parallel Job Structural Differences.
Server features not supported
Feature | Asset Query (?) | Comment |
---|---|---|
Clear file before writing | This query detects Hashed Files that do not have the ‘Clear file before writing’ option checked. This means that your job design will require you to implement a data storage layer replacing your hashed file and will require an appropriate mechanism for preserving | |
Hashed File filesystem storage | S2PX conversion also generates utility Server Jobs intended for the one-time migration of Hashed Files to database tables in a DRS-supported relational database. This query tells you when these load Jobs will be created. |
See Also
© 2015-2024 Data Migrators Pty Ltd.