The recovery_template.sql file is a template for creating target PM_RECOVERY recovery tables for relational databases. It contains general requirements for target support for CDC transactions when writing to relational databases.
You can configure the template for target support for PowerCenter, Informatica Intelligent Cloud Services (IICS), and PowerExchange Cloud Data Integration (CDI).
The installation process copies the recovery_template.sql file to the root installation directory for the Linux, UNIX, and Windows installers. Review and customize the SQL syntax to ensure support for the target database.