...
| Info |
|---|
It is possible to configure a Hash Hashed File stage with a blank account. In this case, an empty string will be passed to the hashing algorithm; this will return the value |
...
Your solution will require a single HASH_DICTIONARY table per schema, as it is accessed through the same connection used to populate the Hashed File database table to which the dictionary refers. The HASH_DICTIONARY table will need to be created manually by a database administrator before your can run S2PX-generated Parallel Jobs which use it. You can see example DDL here.
Referencing
...
Hashed File Database Tables in Jobs
The database table name needs to be provided as a property of the relevant DRS Connector(s) which read and/or write the relevant tables. Unfortunately these properties are established at the point at which the job is invoked and cannot be derived using function calls during job runtime. For this reason each hashed File database name needs to be derived outside the job and the DRS Connector needs to be provided with its table name via a job parameter. Below we describe how this process works.
...