Authorities
and privilegesUse the Invert Data transformer to invert the rows and columns in a table. Optionally, you can specify a pivot column that contains data to be used as column headings when creating the output table. Before you begin this task, you must connect a source table from the warehouse database to the step.
The Invert Data transformer drops the existing database table and recreates it during each run. Each time that you run a step using this transformer, the existing data is replaced, but the table space and table index names are preserved.
A step that uses the Invert Data transformer must be promoted to production mode before you can see the actual data produced.
To define an Invert transformer step:
Specify information for your step:
In the Name field, you can type a new name for the step. Otherwise, you can keep the name that the Data Warehouse Center automatically supplied for the step. This field is required.
In the Administrator field, type the name of the person who is responsible for the maintenance of this step. This field is optional.
In the Description field, type a business description for your step. This description can be a maximum of 255 characters. This field is optional.
In the Notes field, type detailed information that might be helpful to users who can access this step. This field is optional.
On the Parameters page, click a column in the Available columns list. Then, click > to move the selected column to the Pivot column field. If you leave this field empty, the transformer will invert the rows and columns using numbers in place of column names.
Optional: Select the Include sequence column in output check box to create a column in the output table that contains an ordered list of numbers. The list of numbers starts at 1 and increments by 1.
If your step is not connected to a target table, click Create warehouse target table based on parameters.
If you clicked Create warehouse target table based on parameters, select a Warehouse target from the Warehouse target list.
On the Processing Options page, in the Agent Site list, select an agent site where you want your step to run. The selections in this list are agent sites that are common to the source tables, the target table, and the transformer or program that you are defining.
If you want to have the option to to run your step at any time, select the Run on demand checkbox. Your step must be in test or production mode before you can run it.
Optional: Select the Populate externally check box if the step is populated externally, meaning that it is invoked in some way other than by the Data Warehouse Center. The step does not have to have any other means of running in the Data Warehouse Center in order to change the mode to production.
If Populate externally is not selected, then the step must either have a schedule, be linked to a transient table that is input to another step, or be started by another program in order to change the mode to production.
In the Retry area, specify how many times you want the step to run again if it needs to be retried and the amount of time that you want to pass before the next run of the step.
In the Log table field, specify a log table.
In the Trace level field, specify a trace level.
Click OK to save your changes and close the step notebook.
Related information