When you create a mapping in Cloud Data Integration, you can specify SQL statements in the advanced properties for a Netezza source.
You can define the following SQL statements for the source:
Pre-SQL
When you define a pre-SQL statement for a Netezza source in a mapping, the Secure Agent runs the pre-SQL statement before reading data from Netezza.
Post-SQL
When you define a post-SQL statement for a Netezza source in a mapping, the Secure Agent runs the post-SQL statement after reading data from Netezza.
Mapping Scenario with SQL Statements Defined for Netezza Sources
Consider a mapping where you want to read data from a Netezza source and you want to define SQL statements both for the Netezza source:
1Define the following pre-SQL statement for the Netezza source: delete from employee_tgt where job_id is null;
2Define the following post-SQL statement for the Netezza source: update employee set first_name = 'First_name' where employee_id = 2
When you run the mapping, the Secure Agent uses the following sequence for the tasks:
1Runs the pre-SQL statement in the source Netezza database and deletes data of employees whose job IDs show null.
2Reads the data from the Netezza source database.
3Runs the post-SQL statement for staging data populated for another mapping in the Netezza source database and reads data from department1 and employee table based on the department ID.
4Runs the post-SQL statement to insert additional sales data available from the last 10 days into the sales data staging table.