Table of Contents

Search

  1. Preface
  2. Introduction to TDM Administration
  3. User and Role Administration
  4. Security Administration
  5. System Preferences
  6. TDM Server Administration
  7. Connections
  8. Pass Phrases
  9. Global Parameters
  10. Dictionaries
  11. User-Defined Datatypes

Workflow Generation

Workflow Generation

Before users generate workflows, define properties for all data subset and data masking workflows.
To define workflow properties, click
Edit
in the
Workflow Generation
section.
The following table describes the workflow generation properties:
Property
Description
Central seed value is a parameter
Select this option to enter a central seed value as a parameter.
Central Seed Value
Number that overrides the individual seed values that are configured for repeatable output for data masking components. Enter a central seed value to ensure that data masking components return the same masked values in different plans. When you set a central seed value, the PowerCenter Integration Service uses that value for all data masking components with repeatable output. The seed value modifies the logic which is used in data masking operations.
For example, to mask the same CUST_ID column in four tables, such that all of them output the same masked values, set a central seed value. If you use a different seed value for each column, each column returns different masked values. The seed values that you specify ensure that columns return masked values consistently.
Valid values are from 1 through 999. You can enter the central seed value as a parameter.
Cache Location
Directory for index and data cache files that the PowerCenter Integration Service uses when it runs workflows.
Default is
<Informatica _Installation_Directory>/server/infa_shared/cache
.
Maximum Tables in a Mapping
Maximum number of tables that all workflows create for each session. You can override this value when you create a workflow.
If you run the PowerCenter Integration Service on a machine with a fast processor, increase the number of tables to optimize performance.
Default is 20.
Storage Connection
A connection to a database that contains storage tables. The Data Masking transformation maintains 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.
Staging Connection
A connection to a database for creating temporary staging tables. The default set in the Workflow Generation section appears during plan creation. 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.
Mapping Name
Format of the mapping name that TDM creates when you run a plan. You can enter an expression to create a naming format. TDM creates all mappings with names in the same format. Use the expression editor to create the format. If you do not enter a format, the plan assigns a random name.
Workflow Name
Format of the workflow name that TDM creates when you run a plan. You can enter an expression to create a naming format. TDM creates all workflows with names in the same format. Use the expression editor to create the format. If you do not enter a format, the plan assigns a random name.
Session Name
Format of the session name that TDM creates. You can enter an expression to create a naming format. TDM creates all sessions with names in the same format. Use the expression editor to create the format. If you do not enter a format, the plan assigns a random name.
Encrypt Storage
Encrypts storage tables, such as IDM_SUBSTITUTION_STORAGE and IDM_EXPRESSION_STORAGE. Verify that you have encrypted data in storage tables before you enable the encrypt storage property.
Default is No. If you do not want to encrypt the storage tables, select Yes.
If the IDM_SUBSTITUTION_STORAGE and IDM_EXPRESSION_STORAGE tables contain data that is not encrypted, the workflow run fails. You must manually truncate the table in the database.
In a non Windows environment, if the IDM_SUBSTITUTION_STORAGE and IDM_EXPRESSION_STORAGE tables contain data that is not encrypted, the workflow run fails and does not generate an exception.
Modify Storage Encryption Key
Appears if you choose to encrypt the storage tables. Modifies the storage encryption if selected.
Storage Encryption Key
Appears if you choose to encrypt the storage tables. The Data Masking transformation encrypts the storage based on the storage encryption key. Use the same encryption key for each session run of the same Data Masking transformation instance.