Document toolboxDocument toolbox

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.