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

Read the Informatica® Release Notes to learn about known limitations and fixes associated with version 10.5.4. The Informatica version 10.5.4 release includes multiple bug fixes. The Release Notes also include information about upgrade paths and EBFs. Product documentation is updated for every major release even if a guide does not …

What's New and Changed (10.5.4)

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.4.0.1)

Help for Users

Developer Transformation Guide

Use the Informatica® Developer Transformation Guide to learn about the configuration, guidelines, usage, and run-time behavior of Informatica transformations. Understand how to use transformations in appropriate use cases depending on the environment and run-time engine. View the support for each transformation depending on where …

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

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 …

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.

Database View Reference

Refer to the Informatica® Database View Reference for information about the views in the Model repository, profiling warehouse, and Business Glossary. Views for each database are grouped into tables that contain their columns, data types, and descriptions of their columns.

Message Reference

Refer to the Informatica® Message Reference to understand run-time errors that you see in logs and learn what actions you can take based on the error. Error messages in this reference are grouped by message code.

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 …

Upgrading from Version 10.2 (10.5.4)

Follow the instructions in this upgrade guide to upgrade the product. Review the upgrade guide to upgrade the services and clients for the Informatica domain. Verify the database requirements and set up the databases for the domain. You can verify the distributions for the supported products in the native and non-native environments. …

Access Flat Files

In Informatica Developer, you can create a flat file physical data object when you want to use a flat file as a source, lookup, or target. In this demo, we import a flat file to create a flat file data object, configure the data object, 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, you can create a rule and apply it to a column profile. A rule is business logic that defines conditions applied to data when you run a profile. Use rules to validate the data in a profile and measure data quality progress.

Aggregate Data

In Informatica Developer, create an Aggregator transformation to perform aggregate calculations, such as averages and sums. Use the Aggregator transformation to perform calculations on groups of data. You can also use conditional clauses to filter rows.

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, you can create a mapping from a profile. You can then add more objects to the mapping to use it for data quality purposes. When you create a mapping from a profile, the mapping has a data source based on the data object you ran the profile on and contains transformations based on the rule logic in the profile.

Create and Reuse a Mapplet

In Informatica Developer, you can create a mapplet, which is a reusable object that contains a set of transformations. Create a mapplet to reuse the same transformation logic in multiple mappings.

Create and Run a Pass-through Mapping

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

Create and Run a Profile

In Informatica Developer, create a profile on a data source when you want to discover and analyze all data anomalies. You can use profiles to find hidden data problems across data sources that put projects at risk.

Create and Use a Reusable Transformation

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

Create, Deploy, and Run a Workflow

In Informatica Developer, you can create a workflow and add a mapping to the workflow when you want to run multiple mappings sequentially. Or, you can add a mapping to a workflow when you want to run commands to perform steps before and after the mapping runs. The Data Integration Service uses the instructions configured in the workflow to run the objects. In this demo, we will create, deploy, and run a workflow. The workflow first runs a mapping. Then, it runs a command to print a summary of the mapping run to a text file.

Extract Data from a Website using DataSift

In Informatica Developer, you can use DataSift to extract real-time social data from web sites.

Extracting Data from a Website using Kapow Katalyst

Learn how to use the Developer tool to extract data from a website. PowerExchange for Web Content-Kapow Katalyst uses a third-party tool called Kapow Katalyst to extract data from any website.

Extracting Facebook Posts

In Informatica Developer, you can read social media data from websites such as Facebook and LinkedIn. In this demo, we'll see how to use the Developer tool to extract wall posts from Facebook.

Extracting LinkedIn Profiles

In Informatica Developer, you can read social media data from websites such as Twitter and LinkedIn. Learn how to use the Developer tool to search and extract profile information from LinkedIn web.

Extracting Tweets

In Informatica Developer, you can read social media data from websites such as Twitter and LinkedIn. Learn how to use the Developer tool to extract tweets from Twitter.

Generate a Sequence of Numeric Values

In Informatica Developer, you can add a Sequence Generator transformation to a mapping when you want to generate numeric values. Use the Sequence Generator transformation to create unique primary key values or to replace missing primary keys. You can also use the transformation to cycle through a sequential range of numbers.

Import and Preview a Relational Data Object

You can import a relational data object in Informatica Developer to use relational data as a source, target, or lookup in a mapping. In this demo, we import a relational data object, preview the data object, and add the data object as a source in a mapping.

Join Two Data Sources

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

Make a Decision in a Workflow

In Informatica Developer, you can use an Exclusive gateway to make a decision in a workflow.

Parameterize Connections

In Informatica Developer, you can use a mapping parameter to represent a connection. A mapping parameter represents a constant value that can change between mapping runs. This demo explains how to create and use a mapping parameter to change source and target database connections between mapping runs.

Perform a Lookup

In Informatica Developer, create a Lookup transformation when you want to look up data in a lookup source, such as a flat file or relational table. Specify a lookup condition to determine which rows to retrieve from the lookup source. In this demo, we create a Lookup transformation to determine whether each customer placed an order.

Rule and Data Asset Linking to Business Terms in the 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

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, you can add a Notification task to a workflow to send an email during the workflow run.

Sort Data

In Informatica Developer, you can use a Sorter transformation to sort data. In this demo, we'll add a Sorter transformation to a mapping to sort data for a downstream Aggregator transformation. Then, we'll configure the Aggregator transformation to use sorted input.

Transform Unstructured Data

In Informatica Developer, create a Data Processor transformation with a parser to transform a flat file source in PDF or text format to a flat file target in XML format. In this demo, we 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 …

Download Documentation Set

Send Feedback

Resources

Communities

Knowledge Base

Success Portal

Rename Saved Search

Release Information