Test Data Management 9.7.1 HotFix 1
- Test Data Management 9.7.1 HotFix 1
- All Products
A connection to a database for creating temporary staging tables. The default set in the Workflow Generation section appears. You can change the connection used in a plan. Use this connection for scenarios that involve Cyclic Subset, Tending to Cyclic subset, Inplace Batch Updates, Non Relational Shuffle, and Hierarchical PWX.
It is recommended that you use the source connection as the staging connection.
A connection to a database that contains storage tables. The Data Masking transformation maintains the storage tables for repeatable substitution and expression masking between sessions. A storage table row contains the source column and a masked value pair. The storage tables for substitution and expression masking are separate tables, IDM_SUBSTITUTION_STORAGE and IDM_EXPRESSION_STORAGE.
XML date-time format
Appears if the source is an XML file. Date-time format defined in the session properties. Choose one of the following values:
Default is Local Time.
Datetime Format String
Date-time format defined in the session properties. You can enter seconds, milliseconds, microseconds, or nanoseconds.
Default is microseconds.
Enable High Precision
Processes the Decimal datatype to a precision of 28. Default is No.
Tables Per Workflow
Sets the number of tables to process in a workflow. Default is 10.
Use to Reuse or Replace the mapplets in PowerCenter.
Max Parallel Sessions
The maximum number of sessions that can run at the same time. Applicable if you disable indexes and constraints in the target by selecting the options under Target options.
Sets the locale.
A locale properties file corresponding to the locale you select must exist in the
<Informatica installation directory>/TDM/langlocation.
Data Integrity for Subset
Sets the integrity level for major constraints in the source data. Choose one of the following options:
Default is Transactional Integrity for Major Relation Type.
An email address to send notifications to when the plan execution completes. Click settings to configure the email address, subject, and text of the email.
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.
If the target is Cassandra, you must specify the target schema name.
Source Schema Name
Table owner name. Specify the source schema name if the source is in a different schema. 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 the source is Cassandra, you must specify the source schema name.
Enables batch update to update target rows in a batch mode. Improves performance. Use with inplace masking. When you use connection variables, ensure that the staging connection is same as the source connection.
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.
Join parent and child tables using
Choose how to join the parent and the child tables in the SQL. Choose one of the following options:
Enable special characters in metadata
Select whether to allow special characters in plan metadata. Choose one of the following options:
Default is No.
Reset Recovery prefix
Required if you are running the plan to recover records deleted during a failed reset operation. The backup recovery prefix that you entered during the reset operation.
Generate Mappings With Source Data type
Select Yes if the data source was created with the ODBC connection type and if the source table or column names contain special characters. Select Yes when you want to generate a mapping with the actual source data type if ODBC does not support a data type. Applicable for databases that do not have native drivers support on Linux.
Pre 85 Timestamp Compatibility
Trims subseconds to maintain compatibility with versions prior to 8.5. The Integration Service converts the Oracle Timestamp data type to the Oracle Date data type. The Integration Service trims subsecond data for the following sources and targets: