Best Practices for Creating Data Domains Using Rules
Before you create a rule-based data domain, you need to create rules in the Developer tool. Consider the following best practices for the rules that you define in the Developer Tool:
- •If the mapplet contains an Expression transformations, you must enable the Advanced > Maintain row order property in the Developer Tool as shown in the following image:
- •The mapplet output must be of type integer.
- •Do not link the incompatible ports in the mapplet. For example, do not connect a string type port to an integer type port.
- •Expression transformations must not contain multiple variable ports. Instead of creating multiple variable ports, you can use Java transformations in the mapplet.
- •You need to create a mapping with the expression rule and run the mapping in the Spark or Blaze runtime environment. You can then verify the mapping log files before you use the rule to create a data domain in Catalog Administrator.
- •The output transformation must return integer 1 or 0 as the output instead of boolean or string.