Custom Generation
Create custom generation rules to generate data for string, numeric, and date data types.
Custom generation rule is a global rule. To create custom generation rule, import a PowerCenter mapplet. Mark at least one input and one output column as required.
The following image shows the custom generation parameters:
Custom Generation Example
An EMPLOYEES table contains columns for first name and last name. Create and assign standard generation rules to generate first names and last names. Create a custom generation rule to combine the first and last name of an employee to generate the full name in the target table.
Custom Generation Parameters
Configure input and output columns that you import from a mapplet when you create a custom generation rule.
The following table describes the general properties that you can configure for input and output columns:
Parameter | Description |
|---|
Column Name | The name of an input or an output column within a mapplet. When you assign the rule to a column, you map the column names in the rule to column names in the database. |
Column Type | The column type. The mapplet can contain the following types of columns: - - Input. Receives the input data.
- - Output. Returns the output data.
|
Data Type | The data type of the column. |
Precision | The precision for the column. The maximum number of digits or the maximum number of characters that the column can accommodate. For example, 874.560 has a precision of 6. |
Mandatory | Indicates if you must assign the column to a table column in the project. Applies to input and output columns. You must set at least one input and one output column as required. |
Group Name | Specifies the group to which the columns belong. The group name can be input, output, or any other name that you provide when you create a mapplet. |
