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

Advanced Properties

Advanced Properties

The following table describes advanced options that you can override at the data source level and at the table level:
Advanced Options
Description
Datetime Format String
Date-time format defined in the session properties. You can enter seconds, milliseconds, microseconds, or nanoseconds.
  • Seconds. MM/DD/YYYY HH24:MI:SS
  • Milliseconds. MM/DD/YYYY HH24:MI:SS.MS
  • Microseconds. MM/DD/YYYY HH24:MI:SS.US
  • Nanoseconds. MM/DD/YYYY HH24:MI:SS.NS
Default is microseconds.
Target Load Type
Choose Normal or Bulk.
If you select Normal, the PowerCenter Integration Service loads targets normally. Choose Normal mode if the mapping contains an Update Strategy transformation.
Choose Bulk to improve session performance. Bulk load limits the ability to recover because no database logging occurs.
Default is Normal.
Target Schema Name
Table name prefix. Specify the target schema name if the target is in a different schema. Choose to enter a value or parameter. If you choose to enter a parameter, select the parameter name from the list.
If the target is Cassandra, you must specify the target schema name.
If the target is MongoDB, you must not specify the target schema name.
Source Schema Name
Table owner name. Specify the source schema name if the source is in a different schema. Choose to enter a value or parameter. Enter the schema name in uppercase unless the schema name is case sensitive in the database. If the schema name is case sensitive in the database, enter the name as in the database. If you choose to enter a parameter, select the parameter name from the list.
If the source is Cassandra, you must specify the source schema name.
If the source is MongoDB, you must not specify the source schema name.
Source Pre SQL
SQL query executed before the plan is run. Required if you need to perform an operation before you run the plan. Enter the complete SQL statement.
Source Post SQL
SQL query executed after the plan is run. Required if you need to perform an operation after you run the plan. Enter the complete SQL statement.
Batch Size
The number of target rows that you want to move at a time. This option is available when you select the Batch Update as Yes. Use with inplace masking.
The batch size must be greater than the total number of records.
Use Oracle ROWID in Source
Determines whether to use the ROWID from Oracle sources as a column. The ROWID indicates the physical location of a row in the database. Enabled when the Oracle source and target connections are the same.
Performance Hint
Optimizes the SQL query after the plan is run. Enter a performance hint value only for Oracle databases.
.