Transformer Uses 'Rnd()' Function
Rule name | Parallel Transformer uses Rnd() function |
---|---|
Parallel Job | Yes |
Server Job | - |
Job Sequence | - |
Description | Identify the use of a Rnd() function in Parallel Transformers. |
Description
This rule identifies the use of the Rnd()
function in Parallel Transformers. This function produces a different value for every Job invocation, making the Job non-deterministic. This prevents the creation of a Unit Test which includes any column whose output is affected by the Rnd()
function call.
Actions
Replace the Rnd()
call with a Job Parameter which is supplied, in production scenarios, with a random value at runtime. This parameter can then be supplied with a fixed value by a MettleCI Unit Test, resulting in a repeatable (and hence testable) job output.
© 2015-2024 Data Migrators Pty Ltd.