For every primary database table that is staged, there should be a corresponding transformation stored procedure in the replicate SAP IQ database. Replication Server executes these stored procedures against the staging tables, and the results are written to the base tables.
You must specify the transformations to be performed by these stored procedures in an SAP IQ InfoPrimer SQL Transformation project and deploy the stored procedures to the replicate SAP IQ database.
If you attempt to use stored procedures that do not exist in the replicate SAP IQ database, or if a stored procedure fails to execute properly, the replicate database connection will be suspended.