The Filter Tx is an active transformation i.e any transformation which cannot guarantee the rows out will be the same number or in the same order as received.
Mapplets can have active transformations but a rule cannot.
thanks for your response.
I have an another observation for you:
- The rule exist in for the version 9.6.1 and it works.
- We upgraded the IDQ from 9.6.1 to 10.2HF2
how is possible that for the 9.6.1 the rule works and for the 10.2 the rule doens't works?
It shouldn't have worked in 9.6.1 as active Tx have never been supported in rules. The reason it seemed ok in 9.6.1 may have been due to some validation not being performed and this has been corrected in 10.2.
Is it a requirement of integration with PIM that a mapplet must be validated as a rule?
yes, the rule is used in PIM.
Unfortunatly, the old rule is developed by another service integrator so it's hard understand if this module is "useful".
Is there a different way to filter the output in a rule?
In a rule there is no way to filter data as this would make it active i.e. data out does not have the same number of records and order as the input.
Hence why I asked, is it a PIM requirement that only rules can be used or is it possible to use a mapplet? Mapplets are the same as rules with the exception, they can contain an active Tx so while all rules are also mapplets, not all mapplets can be validated as a rule.