What is a Watermark for an Integration Wizard data source query? What are the best practices when defining a watermark?
CAUTION: These commands assume a basic understanding of SQL. Any changes to the Database pose the potential to affect the operation of the product. ALWAYS ENSURE YOU HAVE A BACKUP OF YOUR DATABASE BEFORE MAKING CHANGES.
In order for Symantec to provide full support of the schema and the DB environment, you have to be running the DB in the version specific to the used version as outlined in the System Requirements Guide. Please see the limitations section at http://www.symantec.com/docs/TECH220433
Figure 1 This figure depicts where one would define the watermark for a data source query
Figure 2 This statement depicts a sample process with no Watermark defined, data will be truncated and reloaded nightly
Figure 3 This statement depicts a sample process with a Watermark defined, data will not be truncated from stage, ICA will only add data to the staging table