- Yes, this can be achieved using derivative rules.
- Derivative rules apply logic to the stage data. There are two types of derivative rules, Source and Target.
- Source Derivative rules are created to apply logic defined by the inbound source data in the Stage environment.
- Target Derivative rules are created to apply logic defined by the post-transformed Stage environment data
- The design and reference guide has a lot more information on derivative rules.