Test Data Management
- Test Data Management 10.5
- All Products
Connection Options
| Description
|
---|---|
Treat the subset criteria as a variable
| Appears if you select at least one subset component in a plan. Use the subset criteria as a variable only when there is an entity with a parameter value instead of a specific value in the entity criteria. When you select this option, you must enter the parameter file name and parameter file path.
|
Use Source Connection as Target Connection
| Use the same connection for source and targets. Use with inplace masking.
|
Use Sorter Transformation
| Use a Sorter transformation in the mapping to sort data. Required if the source and staging databases use different sorting techniques.
You cannot use the sorting technique if you select a Hadoop HDFS connection.
|
Use Batch Updates for Recursive Executor
| Update rows in batches in a data subset operation on tables with cyclic or tending to cyclic constraints.
|
Source Connection
| A connection to the source database. Choose a variable, relational, or Hadoop HDFS connection from the list. Select the variable name or select a source connection from the list. If you choose to enter a variable, the list of variables includes global parameters and project parameters. Global parameters are indicated with an asterisk (*).
You cannot use a Hadoop HDFS connection as a variable when you configure a source.
In a Hadoop plan, you can select a Hive or an HDFS connection.
|
Source Connection Directory Path
| Displays if flat file sources are present. Enter the path to the flat file source directory.
|
Target Connection
| Choose a variable, relational, test data warehouse, flat file, or Hadoop HDFS connection from the list. Select a target connection or a variable name from the list. You cannot use a Hadoop HDFS connection as a variable when you configure a target. If you choose to enter a variable, the list of variables includes global parameters and project parameters. Global parameters are indicated with an asterisk (*).
If you enter the target connection as a variable, ensure that you define the scope of the variable as
Global or
Integration Service in the parameter file.
In a multinode setup, if you use parameters to enter the connection information, the parameter file must be present on the node on which the Test Data Manager Service runs. The file must be in the same directory path on both nodes.
In a Hadoop plan, you can select a Hive or an HDFS connection.
|
Target JDBC Connection
| Appears if you select an ODBC target connection type. The connection that contains the JDBC connection string of the ODBC target database.
Required if the target connection type is ODBC and either of the following statements is true:
Optional if the target is ODBC and you want to perform simple data movement operations.
|
Source File Directory
| Appears if the project includes XML sources. Location of the source XML file. Enter the path to the XML source file directory. The source file must reside on the machine on which the PowerCenter Integration Service runs.
Default is the PowerCenter Integration Service process variable directory $PMSourceFileDir.
|
Target File Directory
| Appears if the project includes XML sources. Enter the path to the XML target file directory. The path must be on the machine on which the PowerCenter Integration Service runs.
Default is the PowerCenter Integration Service process variable directory $PMTargetFileDir.
|
Source File Name
| The name of the IMS source file or VSAM source file. If the source is a Hierarchical IMS file, enter the name of the source unload file. If the source is a Hierarchical VSAM/SEQ file, enter the name of the source file. Required if the source connection is PXW_NRDB Batch.
|
Target File Name
| The name of the IMS target file or VSAM target file. If the target is a Hierarchical IMS file, enter the name of the target unload file. If the target is a Hierarchical VSAM/SEQ file, enter the name of the target file. The target file name must be different from the source file name. Required if the target connection is PXW_NRDB Batch.
|
Teradata ODBC Connection
| Name of the Teradata ODBC connection. Required if the target connection is Teradata PT. Select a connection from the list.
|
Dictionary Lookup Connection
| Connection to a database that contains lookup tables. Required if the plan has a dictionary generation rule assignment or a mapplet rule that includes a transformation. Choose relational or flat file from the list. Select a dictionary lookup connection from the list.
|
Dictionary Connection
| A connection to the database that contains the dictionary table. The dictionary connection option does not appear unless the project contains a rule that requires a relational dictionary.
|
Email Dictionary Connection
| A connection to the database that contains the email dictionary table. The email dictionary connection option does not appear unless the project contains a masking rule that requires a relational email dictionary.
|
Number of Records to Generate
| Required. The number of records that you want to generate in the target table when you create a generation plan.
|
Reference Lookup Connection
| A connection to the database that contains parent tables. Required if the generation plan has reference lookup rule assignment. Choose relational or flat file from the list. Select a dictionary lookup connection from the list.
|