Custom Generation Rules
A custom generation rule is a global rule that generates data based on PowerCenter mapplet logic.
You can import a mapplet to create a custom generation rule. You must mark at least one input and one output column as required. Use custom rules to generate data for string, numeric, and date data types.
For example, an EMPLOYEES table contains columns for first name and last name. You create a custom generation rule to combine the first and last name of an employee to generate the full name.
You can also create custom rule with mapplets when you want to use PowerCenter transformations, such as an SQL transformation or a Stored Procedure transformation. You can also use custom mapplets when you need to use the logic to generate records or generate output with the user defined procedure.
Creating a Custom Generation Rule
Create a custom rule using PowerCenter mapplet to generate data.
1. To access the Policies view, click Policies.
2. Click Actions > New > Generation Rule.
The Rule Wizard appears.
3. Enter a name and optional description for the rule.
4. Select the Custom Rule generation type.
5. To select a mapplet from the local folder, click Browse.
6. Click Next.
The Configure Mandatory Columns dialog box appears with a list of input columns and output columns that are available in the mapplet.
7. To mark the columns as required fields, select the columns, and click Set Mandatory.
You must at least select one input column and one output column as required fields.
8. Click Finish.
The custom rule appears as another tab. Review and close the tab.