Create a mapping task to process data based on the data flow logic defined in a mapping or integration template. You can also create a mapping task to capture changed data from the Oracle CDC source and write the changed data to an Amazon Redshift target table. You can switch the mapping to advanced mode to include transformations and functions that enable advanced functionality.
Caution: The pre-SQL and post-SQL commands configured in the Source, Target, and Lookup transformations are not validated at run time. Ensure that the command syntax is free from potentially unsafe content and the database user you configured in the connection object has appropriate privileges. It is recommended to use TLS- enabled database connections for secure network communications.