The Key generator transformation in an active transformation. I could not find the description of "key generator" in the other doc (Transformation types ) that you are referring to. Additionally, that document does applied to "Data Quality".
Regarding the error, a rule can contain only passive transformations. Below is an excerpt from the documentation:
A rule must meet the following requirements:
- The rule must contain an Input and Output transformation. You cannot use data sources in a rule.
- The rule can contain Expression transformations, Lookup transformations, and passive data quality transformations. The rule cannot contain any other type of transformation. For example, a rule cannot contain a Match transformation, as it is an active transformation.
Reference: Mapplet as a Rule Validation
Let me know if this helps.
Thanks for the reply.
Could you help me to understand how "Key Generator" is an active transformation. As per my understanding, it generates SequenceID and GroupKey for each record, which means if there are 100 records in a source table, passing required columns into the Key Generator. The output of Key Generator will be 100 records.
If number of input records are equal to number of output records, then the transformation should be passive. Please correct if I am wrong.
1 of 1 people found this helpful
Passive Tx must be the same number of record in and out and they must be in the same order.
Because the Key Generator Tx allows the records be sorted before output, it is considered active as records may be output in a different order.
The Key Generator transformation organizes records into groups based on data values in a column that you select. The Key Generator transformation uses a grouping strategy to create group keys for the column you select. Records with common values in the selected field have a common group key value.
Hence, it is an Active Transformation.
Please refer to the following guides:
Thanks Robert for the explanation!