Chapter 12 Working with Replication Server

Creating staging tables in Sybase IQ

Once the replication for Sybase IQ and the staging database options are defined you should run the Check Model feature in the Sybase IQ model.

You can then create staging tables in Sybase IQ.

To create staging tables in Sybase IQ:

1. Right-click the Sybase IQ database symbol and select the Create Staging Tables in Sybase IQ command in the contextual menu.

Function strings are added to the RepServer definition to replicate data into the Sybase IQ staging tables.

In the Sybase IQ database PDM, the following new objects are created:

• Insert staging tables if the "Use insert table in Sybase IQ" option is selected.
• Update staging tables if the "Support update in Sybase IQ" option is selected.
• Delete staging tables.
• Stored procedures for RepServer function strings.
• IQ_LOAD_STAGING stored procedure to transfer data from the staging database into Sybase IQ.
• A staging diagram that shows the staging tables and stored procedures.

Copyright (C) 2007. Sybase Inc. All rights reserved.