Authorities and privilegesUse the Define Replication notebook to define a base aggregate replication step. Base aggregate replication steps produce read-only tables that summarize the contents of a source table.
For a replication step, promoting to test status will create the target table and generate the subscription set. The first time a replication step is run, a full refresh copy is made. Promoting a replication step to production status will enable the schedules that have been defined. You can make changes to a step only when it is in development status.
The Data Warehouse Center supports five types of replication: base aggregate, change aggregate, point-in-time, staging table, and user copy (default).
To define a base aggregate replication 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.
Optional: In the Administrator field, type the name of the person who is responsible for the maintenance of this step.
Optional: In the Description field, type a business description for your step. This description can be a maximum of 255 characters.
Optional: In the Notes field, type detailed information that might be helpful to users who can access this step.
On the Parameters page, select the columns that you want to replicate from the Available columns list, and click >. The columns that you select move to the Selected columns list. The Available columns list only shows the columns that have been enabled for change capture.
If you want to include all of the items in the Available columns list, click >>.
Optional: Click Add Calculated Column to open a window in which you can create derived columns. The derived columns that you create are displayed in the Selected columns list.
Optional: If you want to select which rows are to be replicated, write a WHERE statement to subselect rows.
On the Column Mapping page, map the output columns that result from the SQL statement that you defined on the Parameters page to columns on your target table. On this page, output columns from the Parameters page are referred to as source columns. Source columns are listed on the left side of the page. Target columns from the output table linked to the step are listed on the right side of the page. Use the Column Mapping page to perform the following tasks:
To create a mapping, click a source column and drag it to a target column. An arrow is drawn between the source column and the target column.
To delete a mapping, right-click an arrow and select Delete.
If the output table is not used by any steps that are in Test or Production, you can change the attributes of the target column. To rename a target column, double-click the column name and type the new name. You can also modify any other attributes of the target column by double-clicking the attribute.
To move a target column up or down the list, select the column. Then, click the Up arrow or Down arrow buttons. If the target column is mapped to a source column, the mapping remains intact.
If the Parameters page produces no output columns, or if this step is not linked to a target table and you have not specified automatic generation of a default table in the Parameters page, you will not be able to use this page to map your columns. Some steps will not allow you to change the column mapping.
Click OK to save your changes and close the notebook.
Related information