Ab Initio Component | REFORMAT: Part 1

 Purpose of Reformat:

• Reformat Component is used to change the format of records by dropping fields, or by using DML expressions to add fields, combine fields, or transform the data in the records.
•  REFORMAT performs an implicit reformat when you do not define a reformat function or transformation for the fields

 

Parameters for REFORMAT

 

 count (integer, required)

     It is used to sets the number of:

•         out ports
•         reject ports
•         error ports
•         transform parameters

    Default is 1. 

 

select (expression, optional)

•  It is used to filter the records before reformatting 

 

error_group (string, optional)

•  It is name of the error group to which this component belongs. It sends its error output to the HANDLE ERRORS component with a matching error_group value.

 

log_group (string, optional)

•  It is name of the log group to which this component belongs. It sends its log output to the HANDLE LOGS component with a matching log_group value.

reject-threshold (choice, required)

• It is used to specifies the component’s tolerance for reject events.

•  The reject-threshold parameter specifies the component’s tolerance for reject events. Choose one of the following       
  

1. Abort on first reject — The component stops execution of the graph at the first reject event it generates.
2. Never abort — The component does not stop execution of the graph no matter how many reject events it generates.
3. Use limit/ramp — The component uses the settings in the limit and ramp parameters to determine how many reject events to allow before it stops execution of the graph.

 limit(integer, required)

• A number representing reject events.
• When the reject-threshold parameter is set to Use limit/ramp, the component uses the values of the ramp and limit parameters in a formula to determine the component’s tolerance for reject events. 

       Default is 0.  

ramp(real, required)

• Rate of toleration of reject events in the number of records processed.
• When the reject-threshold parameter is set to Use limit/ramp, the component uses the values of the ramp and limit parameters in a formula to determine the component’s tolerance for reject events.
  

    Default is 0.0.

Note:

When you set the reject-threshold parameter of a component to Use limit/ramp, the limit and ramp parameters become available. The component then uses the limit and ramp parameters together in a formula to control the component’s tolerance for reject events:

The component stops execution of the graph if the number of reject events exceeds the result of the following formula:

limit + (ramp *  number_of_records_processed_so_far)