Common Content for Data Integration

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 Notes (10.5.1.1)

Informatica 10.5.1.1 is a service pack that contains information about multiple emergency bug fixes, restricted functionality, known issues, and bug fixes. The service pack supports Informatica Data Quality and all Data Engineering, Data Security, and Data Catalog products. The service pack is available for Linux, and you can download it from …

Release Notes (10.5.1)

Read the Informatica® Release Notes to learn about known limitations and fixes associated with version 10.5.1. The Release Notes also include information about upgrade paths, EBFs, and limited support, such as technical preview or deferments.

What's New and Changed (10.5.1)

See Informatica® What's New and Changed to learn about new functionality and changes for current and recent product releases. You can also read the important notices for information related to support changes, new products, and release tasks that you might need to perform after you upgrade from a previous version. What's New …

What's New and Changed (10.5.1.1)

Help for Users

Developer Tool Guide

Use the Informatica® Developer Tool Guide to learn about the user interface in the Developer tool. Learn how to connect to a Model repository, create connections and data objects, and deploy applications.

Reference Data Guide

Read the Informatica Reference Data Guide to learn about the reference data objects and files that you can use in Informatica Developer and Informatica Analyst. You can use reference data to identify, analyze, enhance, or remove values in your source data based on your business needs.

Help for Administrators

Administrator Guide

Use the Informatica® Administrator Guide to learn how to log into the Administrator tool and understand the user interface. Read on how to configure, manage, and monitor the Informatica domain. Learn about domain architecture and its components, including nodes, services, high availability, connections, and monitoring.

Application Service Guide

Use the Informatica Application Service Guide to understand the application services in the Informatica domain, and learn how to manage each service. You can also learn about application service management concepts and tasks including configuration, processing behavior, architecture, and performance tuning.

Security Guide

Use the Informatica Security Guide to learn how to enable security in an Informatica domain. Understand how to configure and manage various authentication protocols, including Lightweight Directory Access Protocol, Kerberos, and Security Assertion Markup Language. Learn how to manage users and groups, and how to use permissions, …

Reference Material

Transformation Language Reference

Refer to the Informatica® Developer Transformation Language Reference to understand transformation language in the Developer tool. Learn how you can use constants, operators, variables, dates, and functions to transform source data.

Command Reference

Refer to the Informatica® Command Reference for information about the command line programs and utilities, such as infacmd, infasetup, pmcmd, pmpasswd, and pmrep to manage the Informatica domain, application services, and objects. Learn command descriptions, options, and arguments. You can perform much of the command line …

Installation and Upgrade

Installation for PowerCenter and Data Quality

Follow the instructions in Installation for PowerCenter and Data Quality to install Informatica services and the PowerCenter and Informatica Data Quality products. You can install Informatica services and clients on one or more machines. The guide includes pre- and post-requisite tasks and steps to install the Informatica services and …

Additional Content

Common Content for Data Integration 10.5

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.

Configuring Git Version Control for Model Repository Service in 10.2 HotFix 1

You can integrate a Model repository with a Perforce, Subversion, or Git version control system. This article discusses how to integrate a Git system with a Model Repository Service in 10.2 HotFix 1.

Enabling SAML Authentication with NetScaler for Web Applications

You can enable users to log into Informatica web applications using single sign-on. This article explains how to configure single sign-on in an Informatica domain using Security Assertion Markup Language (SAML) v2.0 and the Citrix NetScaler 13.0 identity provider.

Optimize and Tune

Tuning the Hardware and Hadoop Cluster for Informatica Big Data Products

You can tune the hardware and the Hadoop cluster for better performance of Informatica big data products. This article provides tuning recommendations for Hadoop administrators and system administrators who set up the Hadoop cluster and hardware for Informatica big data products.

Security

How to Create Keystore and Truststore Files for Secure Communication in the Informatica Domain

When you enable secure communication for the Informatica domain, you secure the connection between services and between the services and the service managers. For better security, you can provide a custom SSL key and certificate. This article describes how to create keystore and truststore files in PEM and JKS formats with a custom SSL …