Because Hashed File stages exist in Server but are not supported in Parallel . Due to this, jobs an alternative solution must be provided to convert a Server job, that includes Hash File stages, to a parallel job. The S2PX process translates Hashed File stages to DRS Connector stages and also provides “Hash File Migration” Server jobs to migrate the existing hash files to database tablessupport the use of Hashed File-stored data in a Parallel job. For each Hashed File stage encountered in a Server job S2PX will:

• Translate the Hashed File stage to its Parallel equivalent (a DRS stage), and

• Generate a new, entirely separate utility Server job which is intended for the one-off loading of Hashed File data into a DRS-compatible database table.

This page discusses the structure and usage of these Hashed File migration jobs.

Behaviour

These migration jobs will read data from Hashed Files and write them to database tables (the job will drop the table if it already exists, then create the table). There will be a one-to-one relationship between Hashed Files and tables. There will also be a one-to-one relationship between original jobs (that include Hashed File stages) and migration jobs.

...