This content is shared by multiple products within the Data Integration product family. Visit the product pages to see content that is specific to each product.

Release Information

Help for Users

Help for Administrators

Reference Material

Installation and Upgrade

Access Flat Files

In Informatica Developer, learn how to create a flat file data object, configure and preview the data object, run a profile on the data object, and then add the data object as a source in a mapping.

Access Web Services

In Informatica Developer, add a Web Service Consumer transformation to a mapping when you want to connect to a web service to access or transform data.

Add a Rule to a Column Profile

In Informatica Developer, learn how to create a rule and apply it to a column profile. 

Aggregate Data

In Informatica Developer, learn how to create an Aggregator transformation to perform aggregate calculations, such as averages and sums. 

Concatenate Two Fields

In Informatica Developer, concatenate two fields when you want to combine data from two different fields into one field. Use the CONCAT function in an Expression transformation to concatenate the fields. In this demo, we concatenate the first name and last name of each customer to create the full name.

Connect to the Repository

In Informatica Developer, you can connect to the Model repository to create, view, and manage metadata. Each time you open the Developer tool, you must connect to the Model repository to access projects and folders.

Create a Mapping from a Profile

In Informatica Developer, learn how to create a mapping from a profile and add more objects to the mapping to use it for data quality purposes. 

Create and Reuse a Mapplet

In Informatica Developer, learn how to create a mapplet to reuse the same transformation logic in multiple mappings.

Create and Run a Pass-through Mapping

In Informatica Developer, learn how to create a pass-through mapping to move source data to a target without transforming it.

Create and Run a Profile

In Informatica Developer, learn how to create a profile on a data source when you want to discover and analyze all data anomalies. 

Create and Use a Reusable Transformation

In Informatica Developer, learn how to create a reusable transformation that you can use in multiple mappings or mapplets.

Create, Deploy, and Run a Workflow

In Informatica Developer, learn how to create, deploy, and run a workflow.

Generate a Sequence of Numeric Values

In Informatica Developer, learn how to add a Sequence Generator transformation to a mapping when you want to generate numeric values or cycle through a sequential range of numbers.

Import and Preview a Relational Data Object

Learn how to import a relational data object in Informatica Developer, preview the data object, and add the data object as a source in a mapping.

Join Two Data Sources

In Informatica Developer, learn how to use a Joiner transformation to join source data from two related heterogeneous sources.

Make a Decision in a Workflow

In Informatica Developer, learn how to use an Exclusive gateway to make a decision in a workflow.

Parameterize Connections

In Informatica Developer, learn how to create and use a mapping parameter to change source and target database connections between mapping runs.

Perform a Lookup

In Informatica Developer, learn how to create a Lookup transformation to look up data in a lookup source, such as a flat file or relational table. 

Rule and Data Asset Linking to Business Terms in the Analyst Tool

In Informatica Analyst Tool, learn how to link a rule asset to a business term, and how to create a rule specification from a rule intent in a business term.

Preview Data

In Informatica Developer, learn how to preview data in a physical data object, preview data midstream in a transformation, customize the data preview options, and export the output data that you previewed.

Send an Email from a Workflow

In Informatica Developer, learn how to add a Notification task to a workflow to send an email during the workflow run.

Sort Data

In Informatica Developer, learn how to use a Sorter transformation to sort data. 

Transform Unstructured Data

In Informatica Developer, learn how to create a Data Processor transformation, create and configure a script with a parser, preview the example source, define the parser, preview the Data Processor transformation, and then add the Data Processor transformation to a mapping.