You can create a subset of a data pack in the self-service portal in Test Data Management (TDM). You can run a job to view related data and compute the subset data before you create the subset. This article provides the steps to compute the results of subset criteria and run a job to create a subset of a data pack. This article assumes …

You can create a test data warehouse to store test data in Test Data Management (TDM). This article documents the steps to create a test data warehouse and run a TDM operation to store data in the test data warehouse. This article assumes that you have knowledge of TDM and are familiar with TDM operations.

In Test Data Management (TDM), you can create and assign standard data masking rules to mask sensitive data. This article describes how to create random and shuffle masking rules, assign the rules to target columns, and create and run a plan to mask the source data.

You can run profiles to discover primary keys, entities, and data domains in Test Data Management (TDM). This article documents the steps to perform data domain discovery in TDM.

In TDM, you can use Hadoop connections when you want to lower the cost of raw data storage and solve large scale analytics by using the distributed computing feature of Hadoop. You can perform data domain profiling, data masking, and data movement on Big Data Edition Hadoop clusters. This article describes how to perform data domain …

In Test Data Management (TDM), you can generate credit card numbers based on the type of the card. You can choose from multiple credit card number formats. This article describes how to create and use the data generation rules to generate test credit card numbers based on the network types.

You can import profiles that you create in Informatica Developer into Test Data Manager. This article documents the steps to create a data domain profile in Informatica Developer and import the profile into Test Data Manager. This article assumes that you have knowledge of Informatica Developer and Test Data Management (TDM) and are …

In Test Data Manager, you can import flat file metadata sources from the PowerCenter repository to perform Test Data Management (TDM) operations. This article describes how to import a flat file metadata into the PowerCenter repository, import metadata from the flat file sources in Test Data Manager, and configure flat file settings in a …

You can use data in a Netezza database to perform tasks in Test Data Management (TDM). This article describes the steps to create a Netezza connection and import metadata from a Netezza connection in Test Data Manager. This article assumes that you have knowledge of TDM and are familiar with TDM operations.

You can use XML sources to perform tasks in Test Data Management (TDM). This article describes the steps to import metadata from an XSD file in Test Data Manager. This article assumes that you have knowledge of TDM and are familiar with TDM operations.

You can perform TDM operations on Teradata sources in Test Data Management (TDM). This article describes the steps to import metadata from a Teradata database and to create a Teradata connection in Test Data Manager. This article assumes that you have knowledge of TDM and are familiar with TDM operations.

Import metadata from Cassandra and MongoDB data sources into Test Data Manager and perform Test Data Management (TDM) operations. This article describes how to configure data source names for Cassandra and MongoDB sources, import metadata into PowerCenter®, import metadata into TDM, and create ODBC connections for Cassandra and …

You can perform Test Data Management (TDM) operations on Hive and Hadoop Distributed File System (HDFS) data sources in a Hadoop environment in Test Data Manager. You must configure a Hadoop environment before you can create the connections in Test Data Manager. You can then import metadata from the source connections to perform TDM …

You can perform TDM operations on databases with bulk data, and on source and target databases on a mainframe environment in Test Data Management (TDM). This article describes the steps to import metadata from a database on a mainframe environment, or from databases for bulk data movement, and to create connections to databases in Test …

You can create a relational database connection and import metadata from the connection in Test Data Management (TDM). Use the imported metadata to perform TDM operations. This article describes how to create a relational database connection, create a project, and import metadata directly from the database connection.

You can use Test Data Management REST APIs to automate tasks that you perform in Test Data Management (TDM). This article describes how you can use cURL to run TDM REST APIs. cURL is a command line tool and library for transferring data with URLs. It is used in command lines or scripts to transfer data.

In Persistent Data Masking and Data Subset, you can use an advanced rule to take input from two different tables and generate the output. This article describes how to create an advanced rule, join two tables with the rule, and edit the advanced rule.

You can perform data coverage analysis on test data that you store in the test data warehouse in Test Data Management (TDM). This article provides the steps to perform data coverage analysis in TDM with a specific example. This article assumes that you have knowledge of TDM and are familiar with TDM operations.

This document explains how a reset operation works and how each configuration option impacts the reset operation. It also explains, with an example, when and why you should choose one configuration over the other. It assumes that you have knowledge of TDM and data sets in TDM.

In Test Data Manager, you can create a column profile and extrapolate the profile results to generate test data. TDM analyzes column data and infers rules based on the data. This article describes how to create and run a column profile, assign auto rules to target columns, and run an ad hoc generation plan to generate test data.

In Test Data Management (TDM), you can use PowerCenter mapplets to mask data. A mapplet contains the logic to mask the input columns and return the output to the target columns. This article describes how to create a mapplet rule, assign the rule to target columns, create a plan, and generate and run a workflow to mask the sensitive data.

You can use Test Data Management (TDM) to perform tasks with Kerberized Microsoft SQL Server connections in a Kerberos environment. This article describes the steps to create a Kerberized Microsoft SQL Server connection and perform data masking when Informatica service and Test Data Management are installed in a Kerberos environment.

In Test Data Manager, you can create and assign data generation rules to generate test data in the target columns. Create conditional constraints to restrict the test data that you want to generate in a target column based on the data in another column. This article describes how to create and use a random date generation rule and a …

In Test Data Manager, create and assign standard generation rules to the target columns to generate test data. This article describes how to create and assign standard generate rules, create data generation plan, and run the workflow.

You can integrate a test tool with Test Data Management (TDM). Integrate a test tool with TDM to directly export the results of a TDM operation as a flat file to the test tool server. This article documents the steps to integrate an HP Application Lifecycle Management (HP ALM) server with TDM and to export test data from TDM to the HP ALM …

This document explains how major relationships and minor relationships work between tables in an entity in Test Data Management (TDM). It assumes that you have knowledge of the data subset feature in TDM. With sample data, the document explains how the relationship assigned to tables and the filter assignment can impact the output in a data subset operation.

You can edit the advanced properties of the Data Integration Service to improve the performance of a data domain profile that runs in Test Data Management (TDM). This article describes how to configure the advanced properties from Informatica Administrator. This article assumes that you have knowledge of the data discovery feature in TDM …

When you upgrade from a previous version, follow the supported upgrade paths to ensure a smooth and successful upgrade. This article includes upgrade paths for all products supported in the 10.5.1 Informatica installer.

When you upgrade from a previous version, follow the supported upgrade paths to ensure a smooth and successful upgrade. This article includes upgrade paths for all products supported in the 10.5 Informatica installer.

You must install and configure a Hadoop environment if you want to perform Test Data Management (TDM) operations with Hadoop connections. The article describes how to install a Hadoop environment, configure the Data Integration Service, and configure Hive and Hadoop Distributed File System (HDFS) connections.