• Success
    Manage your Success Plans and Engagements, gain key insights into your implementation journey, and collaborate with your CSMs
    Success
    Success Accelerators
    Accelerate your Purchase to Value engaging with Informatica Architects for Customer Success
    My Engagements
    All your Engagements at one place
  • Communities
    A collaborative platform to connect and grow with like-minded Informaticans across the globe
    Communities
    Product Communities
    Connect and collaborate with Informatica experts and champions
    Discussions
    Have a question? Start a Discussion and get immediate answers you are looking for
    User Groups
    Customer-organized groups that meet online and in-person. Join today to network, share ideas, and get tips on how to get the most out of Informatica
    Get Started
    Community Guidelines
  • Knowledge Center
    Troubleshooting documents, product guides, how to videos, best practices, and more
    Knowledge Center
    Knowledge Base
    One-stop self-service portal for solutions, FAQs, Whitepapers, How Tos, Videos, and more
    Support TV
    Video channel for step-by-step instructions to use our products, best practices, troubleshooting tips, and much more
    Documentation
    Information library of the latest product documents
    Velocity (Best Practices)
    Best practices and use cases from the Implementation team
  • Learn
    Rich resources to help you leverage full capabilities of our products
    Learn
    Trainings
    Role-based training programs for the best ROI
    Certifications
    Get certified on Informatica products. Free, Foundation, or Professional
    Product Learning Paths
    Free and unlimited modules based on your expertise level and journey
    Experience Lounge
    Self-guided, intuitive experience platform for outcome-focused product capabilities and use cases
  • Resources
    Library of content to help you leverage the best of Informatica products
    Resources
    Tech Tuesdays Webinars
    Most popular webinars on product architecture, best practices, and more
    Product Availability Matrix
    Product Availability Matrix statements of Informatica products
    SupportFlash
    Monthly support newsletter
    Support Documents
    Informatica Support Guide and Statements, Quick Start Guides, and Cloud Product Description Schedule
    Product Lifecycle
    End of Life statements of Informatica products
    Ideas
    Events
    Change Request Tracking
    Marketplace
| Sign up
Videos → Support Videos → Masking Advanced Rule with wrapper variable in Test Data Management 9.6.1
02:40
1535 Views | 20 Mar 2015
Add to Favorites
Remove from Favorites

Masking Advanced Rule with wrapper variable in Test Data Management 9.6.1

In Test Data Management 9.6.1 when using an Advanced Masking Rule with substitution and IIF expression, depending on how the rule is built you can have an invalid mapping (parse error, invalid symbol reference). This support video will help you resolve this issue by using a wrapper variable.

Data Security

Informatica Support 71/117
How to use Packet capturing tools - Tcpdump and Wireshark
playIcon
06:01

How to use Packet capturing tools - Tcpdump and Wireshark
How to run and use the Nearline ssavalidate script in ILM Nearline for Use with SAP 6.1
playIcon
09:30

How to run and use the Nearline ssavalidate script in ILM Nearline for Use with SAP 6.1
How to view the archived data in Data Discovery
playIcon
05:44

How to view the archived data in Data Discovery
How to upgrade 9.5.2 HotFix 2/3 to TDM 9.6.1
playIcon
11:05

How to upgrade 9.5.2 HotFix 2/3 to TDM 9.6.1
Configuring JDBC ODBC Bridge with Data Archive
playIcon
12:04

Configuring JDBC ODBC Bridge with Data Archive
Masking Rule Assignments in Test Data Management
playIcon
03:41

Masking Rule Assignments in Test Data Management
How to Perform Data Masking in TDM
playIcon
12:06

How to Perform Data Masking in TDM
How to connect to database and import tables in EDM
playIcon
04:53

How to connect to database and import tables in EDM
Error: "Assignment missing in classification system" in Informatica TDM Data Subset for SAP 6.1D
playIcon
03:01

Error: "Assignment missing in classification system" in Informatica TDM Data Subset for SAP 6.1D
How to perform Data Profiling in TDM
playIcon
14:47

How to perform Data Profiling in TDM
LDAP Error code 1 remaining name when synchronizing LDAP users
playIcon
05:07

LDAP Error code 1 remaining name when synchronizing LDAP users
Using Parallel and Cardinal Hint
playIcon
07:43

Using Parallel and Cardinal Hint
How to create source and target connections in Informatica Data Archive
playIcon
03:45

How to create source and target connections in Informatica Data Archive
How to run a archive job for audit log files in AMHOME schema in ILM
playIcon
07:54

How to run a archive job for audit log files in AMHOME schema in ILM
How to run and use the Project Statistics Report contained in Informatica Data Subset
playIcon
08:45

How to run and use the Project Statistics Report contained in Informatica Data Subset
Data Subset - entity and group
playIcon
14:41

Data Subset - entity and group
Creating a custom entity with tables having constraints
playIcon
14:10

Creating a custom entity with tables having constraints
How to create parameters and use them in the reports in JReport Designer
playIcon
08:30

How to create parameters and use them in the reports in JReport Designer
How to apply retention policy on unrelated tables
playIcon
03:58

How to apply retention policy on unrelated tables
Test Data Generation TDM 9 6 0
playIcon
04:49

Test Data Generation TDM 9 6 0
How to create a single table group with selection capability using Data Subset for use with SAP KB
playIcon
12:48

How to create a single table group with selection capability using Data Subset for use with SAP KB
How to change Major-Minor Relationships in Test Data Management 9.5.2 HotFix 3
playIcon
06:40

How to change Major-Minor Relationships in Test Data Management 9.5.2 HotFix 3
How to create an archive folder Informatica Data Vault
playIcon
04:40

How to create an archive folder Informatica Data Vault
How to include a new SAP table without using Maintain Schema transaction
playIcon
05:06

How to include a new SAP table without using Maintain Schema transaction
How to mask data for specific users using Dynamic Data Masking tool
playIcon
10:17

How to mask data for specific users using Dynamic Data Masking tool
How to retrieve latest applimation log from ILM Web Console
playIcon
02:31

How to retrieve latest applimation log from ILM Web Console
Random Number Generator in TDM 9.6
playIcon
07:23

Random Number Generator in TDM 9.6
DDM for SQLServer (Configuration & Masking
playIcon
13:48

DDM for SQLServer (Configuration & Masking
How to add HR Infotypes to Informatica TDM Data Subset for use with SAP
playIcon
07:49

How to add HR Infotypes to Informatica TDM Data Subset for use with SAP
How to Manage Tags in ILM Data Archive 6 2
playIcon
07:36

How to Manage Tags in ILM Data Archive 6 2
Issues finding type when generating workflow for SQL Server Sources in ILM TDM 9.6.1 Hotfix 1
playIcon
03:30

Issues finding type when generating workflow for SQL Server Sources in ILM TDM 9.6.1 Hotfix 1
How to create a Table report in Data Visualization
playIcon
04:25

How to create a Table report in Data Visualization
Search and Index Management in TDM 9.5.2 Hotfix 3
playIcon
04:00

Search and Index Management in TDM 9.5.2 Hotfix 3
TDM Data Subset for SAP Discovery Process Overview
playIcon
10:56

TDM Data Subset for SAP Discovery Process Overview
How to export data from Data Vault using Data Discovery
playIcon
07:48

How to export data from Data Vault using Data Discovery
How to validate a data discovery entity in ILM
playIcon
03:56

How to validate a data discovery entity in ILM
Different Reports in Test Data Management 9.5.2
playIcon
05:33

Different Reports in Test Data Management 9.5.2
TDM Data Subset for use with SAP error message No Authorization for S TABU DIS
playIcon
05:53

TDM Data Subset for use with SAP error message No Authorization for S TABU DIS
How to create custom templates when using Data Subset for use with SAP v6 1d
playIcon
09:50

How to create custom templates when using Data Subset for use with SAP v6 1d
How to change reset ILM Repository user password
playIcon
05:42

How to change reset ILM Repository user password
How to set search options for a data discovery entity in ILM
playIcon
03:22

How to set search options for a data discovery entity in ILM
How to create a Virtual View in Enterprise Data Manager EDM
playIcon
04:19

How to create a Virtual View in Enterprise Data Manager EDM
How to create a user defined role and assign it to an entity in Data Archive
playIcon
05:03

How to create a user defined role and assign it to an entity in Data Archive
Creation of Advanced Email Masking Rule
playIcon
07:57

Creation of Advanced Email Masking Rule
EDM Business Rules in ILM Data Archive
playIcon
02:17

EDM Business Rules in ILM Data Archive
How to perform entity profiling in Test Data Management 9.5.2 Hotfix 2
playIcon
05:02

How to perform entity profiling in Test Data Management 9.5.2 Hotfix 2
Configuring Auto Cascade in Test Data Management 9.5.x
playIcon
09:07

Configuring Auto Cascade in Test Data Management 9.5.x
Protecting Sensitive Data in Development and Test Environments Using Persistent Data Masking PDM
playIcon
56:34

Protecting Sensitive Data in Development and Test Environments Using Persistent Data Masking PDM
TDM Data Subset for SAP Project Creation Overview
playIcon
10:51

TDM Data Subset for SAP Project Creation Overview
Installation of ILM Data Archive 6 1
playIcon
05:45

Installation of ILM Data Archive 6 1
How to use Key Masking to generate integer numbers on NUMBER columns with no precision and scale
playIcon
03:30

How to use Key Masking to generate integer numbers on NUMBER columns with no precision and scale
How to create custom selectors for Data Subset for use with SAP v6 1D
playIcon
11:13

How to create custom selectors for Data Subset for use with SAP v6 1D
How to create Relational Dictionary in Test Data Management
playIcon
07:36

How to create Relational Dictionary in Test Data Management
How to create a Query report in Data Visualization
playIcon
05:17

How to create a Query report in Data Visualization
How to configure Log loader in Dynamic Data Masking
playIcon
10:21

How to configure Log loader in Dynamic Data Masking
How to run a job in ILM Data Archive
playIcon
08:16

How to run a job in ILM Data Archive
Analyzing the Archive Cycle logs using the logs sql script
playIcon
05:44

Analyzing the Archive Cycle logs using the logs sql script
IDD Charts Configuration in MDM 9.x
playIcon
04:25

IDD Charts Configuration in MDM 9.x
How to export and purge the audit logs in Data Archive
playIcon
05:32

How to export and purge the audit logs in Data Archive
TDM Data Subset for SAP Thread Manager overview
playIcon
08:21

TDM Data Subset for SAP Thread Manager overview
How to upload a custom JDBC Driver to ILM
playIcon
03:16

How to upload a custom JDBC Driver to ILM
Informatica Nearline for SAP BW Archive Job
playIcon
10:47

Informatica Nearline for SAP BW Archive Job
How to use Command Line Program in TDM 9.5.2
playIcon
07:04

How to use Command Line Program in TDM 9.5.2
How to reset amadmin password for ILM Data Archive 6.1.1/ 6.2
playIcon
03:31

How to reset amadmin password for ILM Data Archive 6.1.1/ 6.2
Data Visualization in Informatica Data Archive 6.2
playIcon
06:55

Data Visualization in Informatica Data Archive 6.2
Informatica Data Subset for use with SAP custom entity
playIcon
09:58

Informatica Data Subset for use with SAP custom entity
How to export an entity for Visualization Option
playIcon
03:38

How to export an entity for Visualization Option
Error message "Target system is a productive system" in TDM Data Subset for SAP 6.1D
playIcon
03:41

Error message "Target system is a productive system" in TDM Data Subset for SAP 6.1D
Importance of rule simulator in TDM
playIcon
05:19

Importance of rule simulator in TDM
Load External Attachments in Data Archive 6 2
playIcon
06:17

Load External Attachments in Data Archive 6 2
Masking Advanced Rule with wrapper variable in Test Data Management 9.6.1
playIcon
02:40

Masking Advanced Rule with wrapper variable in Test Data Management 9.6.1
How to download and publish the reports To and From the Visualization server
playIcon
08:31

How to download and publish the reports To and From the Visualization server
How to mask data using encryption in TDM 9.5.x
playIcon
04:57

How to mask data using encryption in TDM 9.5.x
Creating Seamless Access setup for OEBS
playIcon
13:17

Creating Seamless Access setup for OEBS
How to create a Security group for a source connection in Informatica Data Archive
playIcon
03:18

How to create a Security group for a source connection in Informatica Data Archive
Key Range Partition in Test Data Management 9.5.2 HotFix 2
playIcon
06:38

Key Range Partition in Test Data Management 9.5.2 HotFix 2
How to switch the display language for TDM Workbench
playIcon
02:37

How to switch the display language for TDM Workbench
Data Visualization menu becomes hidden after applying ILM EBF 12629
playIcon
03:16

Data Visualization menu becomes hidden after applying ILM EBF 12629
TDM Data Subset for SAP End Point Overview
playIcon
08:47

TDM Data Subset for SAP End Point Overview
Troubleshooting FAS Update Schema failing with the error in ILM 5.3.6
playIcon
05:02

Troubleshooting FAS Update Schema failing with the error in ILM 5.3.6
Un Mine custom metadata from ILM EDM
playIcon
08:30

Un Mine custom metadata from ILM EDM
How to create an archive entity in Informatica Data Archive
playIcon
12:16

How to create an archive entity in Informatica Data Archive
Creating and Applying Retention Policies in ILM
playIcon
12:04

Creating and Applying Retention Policies in ILM
SAP cluster pool table extraction with ILM dummy job
playIcon
04:04

SAP cluster pool table extraction with ILM dummy job
ILM Performance Monitor- Data Collection Software
playIcon
07:44

ILM Performance Monitor- Data Collection Software
How to create a new catalog and report in JReport Designer
playIcon
09:04

How to create a new catalog and report in JReport Designer
How to replace a certificate in TDM 9 5
playIcon
05:18

How to replace a certificate in TDM 9 5
How to use session workflow parameters in TDM workflows
playIcon
02:56

How to use session workflow parameters in TDM workflows
How to maintain TDM Data Subset for SAP product license
playIcon
07:29

How to maintain TDM Data Subset for SAP product license
How to Install Accelerators for TDM 9.5.2
playIcon
05:11

How to Install Accelerators for TDM 9.5.2
How to deal with LDAP referrals in Active Directory in ILM Data Archive 6.1.1
playIcon
07:22

How to deal with LDAP referrals in Active Directory in ILM Data Archive 6.1.1
Dictionary management in Test Data Management 9.5.2
playIcon
06:08

Dictionary management in Test Data Management 9.5.2
How to install Informatica Smart Partitioning Manager
playIcon
08:06

How to install Informatica Smart Partitioning Manager
How to generate Table DDLs in ILM Data Archive
playIcon
04:30

How to generate Table DDLs in ILM Data Archive
Configuring Datatype Mappings in Data Archive
playIcon
14:44

Configuring Datatype Mappings in Data Archive
How to use Rule Simulator in Test Data Management 9.6
playIcon
05:02

How to use Rule Simulator in Test Data Management 9.6
How to download and install Informatica ILM Performance Monitor
playIcon
05:32

How to download and install Informatica ILM Performance Monitor
Importance of seed value in masking rule for TDM
playIcon
11:25

Importance of seed value in masking rule for TDM
HOW TO Install EBF for ILM Data Archive 6 1 1
playIcon
05:44

HOW TO Install EBF for ILM Data Archive 6 1 1
How to turn on audit logs in Data Archive?
playIcon
05:50

How to turn on audit logs in Data Archive?
Creating Custom Application inside of EDM and verifying it
playIcon
04:57

Creating Custom Application inside of EDM and verifying it
Data domain profiling in TDM 9.5.x
playIcon
10:39

Data domain profiling in TDM 9.5.x
Keyword Search in Data Archive
playIcon
04:10

Keyword Search in Data Archive
How to create reports using imported SQLs in JReport Designer
playIcon
07:12

How to create reports using imported SQLs in JReport Designer
Data Vault Administration in Informatica Data Archive 6.2
playIcon
06:49

Data Vault Administration in Informatica Data Archive 6.2
ILM Data Archive How to create a user and assign roles to the user
playIcon
05:18

ILM Data Archive How to create a user and assign roles to the user
Leveraging Database partitions in Informatica TDM 952 HF2
playIcon
06:06

Leveraging Database partitions in Informatica TDM 952 HF2
How to create mutlitple session using TDM 9.5.2 HotFix 2
playIcon
05:16

How to create mutlitple session using TDM 9.5.2 HotFix 2
Job Auto Refresh Status in ILM Data Archive
playIcon
03:23

Job Auto Refresh Status in ILM Data Archive
Creating a report against Informatica ILM File Archive Server using iReportDesigner Professional
playIcon
11:53

Creating a report against Informatica ILM File Archive Server using iReportDesigner Professional
How to create a Retirement Entity in Informatica Data Archive
playIcon
09:08

How to create a Retirement Entity in Informatica Data Archive
How to configure Primary Key Profiling in Test Data Management 9.5.2 HotFix 2
playIcon
05:23

How to configure Primary Key Profiling in Test Data Management 9.5.2 HotFix 2
How to search for ILM job history
playIcon
03:44

How to search for ILM job history
Configure Data Subset for SAP threads to stay an Idle state prior to going to a Stopped state
playIcon
05:59

Configure Data Subset for SAP threads to stay an Idle state prior to going to a Stopped state
Preparing the AP PO Entities for TXN Restore
playIcon
03:49

Preparing the AP PO Entities for TXN Restore
How to launch the standalone EDM from Windows Machine
playIcon
03:18

How to launch the standalone EDM from Windows Machine
How to create groups without selection criteria in TDM Data Subset for SAP
playIcon
05:52

How to create groups without selection criteria in TDM Data Subset for SAP
Back To Top

Success

Link Copied to Clipboard