Table of Contents

Search

  1. Preface
  2. Introduction to Test Data Management
  3. Test Data Manager
  4. Projects
  5. Policies
  6. Data Discovery
  7. Creating a Data Subset
  8. Performing a Data Masking Operation
  9. Data Masking Techniques and Parameters
  10. Data Generation
  11. Data Generation Techniques and Parameters
  12. Working with Test Data Warehouse
  13. Analyzing Test Data with Data Coverage
  14. Plans and Workflows
  15. Monitor
  16. Reports
  17. ilmcmd
  18. tdwcmd
  19. tdwquery
  20. Data Type Reference
  21. Data Type Reference for Test Data Warehouse
  22. Data Type Reference for Hadoop
  23. Glossary

Target Pre and Post SQL Statements

Target Pre and Post SQL Statements

You can choose to configure SQL statements to run on a target before and after you write data to the target.
For example, you can alter the names of tables or schemas before or after you write the data to the target.
Configure the SQL statements when you configure a plan. You configure the SQL statements in the
Advanced Options
section of a plan. Click
Edit
to open the
Configure Expression
dialog box.
You can use $SCHEMA and $TABLENAME variables in SQL statements that you configure.
For example:
ALTER TABLE <target table name> RENAME TO $TABLENAME;
The SQL statement changes a specific table name in the target to the name that you specify in the $TABLENAME variable. When you include the statement in a plan, the workflow runs the SQL statement on the target and makes the change.
You can configure statements to run before or after you write data, or both before and after you write data to the target.