Informatica Data Quality Developer Fundamentals

Functional Roles and Responsibilities

Technical Roles and Responsibilities - Part 1

Technical Roles and Responsibilities - Part 2

Testing Roles and Responsibilities

Analyst Vs Developer

Quick Overview on Pre-Requisites of Informatica 10.2 Installation

Informatica 10.2 Server Installation on Linux

Informatica 10.2 Client Installation on Windows

A quick overview on how the Informatica Architecture is weaved into have the Informatica Data Quality services and the communication setup between Informatica Power Center and Informatica Data Quality.

This lecture covers the steps to start the Oracle Services and the Informatica Services.

Steps on how to add a connection in Administration Console

Informatica Developer MRS configuration

Informatica Developer Layout Overview

Launching the Developer, Repository Configuration

Projects, Folders and Permissions

A transformation is an object that generates, modifies, or passes data.

Active Transformations An active transformation changes the number of rows that pass through a transformation. Or, it changes the row type.

Passive Transformations A passive transformation does not change the number of rows that pass through the transformation, maintains the transaction boundary, and maintains the row type.

Unconnected Transformations Transformations can be connected to the data flow, or they can be unconnected. An unconnected transformation is not connected to other transformations in the mapping. An unconnected transformation is called within another transformation, and returns a value to that transformation.

Multi-Strategy Transformations: A strategy is a set of one or more operations that a transformation can perform on data. You can assign a different set of input ports and output ports to each strategy in a transformation. The transformation stores the strategies that you define in a single transformation object.

Tracing Level for Transformations:

Terse:  Integration Service logs initialization information, error messages, and notification of rejected data.

Normal:  Integration Service logs initialization and status information, errors encountered, and skipped rows due to transformation row errors. Summarizes session results, but not at the level of individual rows.

Verbose Initialization:  In addition to normal tracing, the Integration Service logs additional initialization details, names of index and data files used, and detailed transformation statistics.

Verbose Data:  In addition to verbose initialization tracing, the Integration Service logs each row that passes into the mapping. Also notes where the Integration Service truncates string data to fit the precision of a column and provides detailed transformation statistics.

Steps to create new folders and adding permissions

Basic example for Expression Transformation in IDQ.

Aggregator Transformation Properties and Example

The Lookup transformation is a passive or active transformation that looks up data in a flat file, logical data object, reference table, or relational table. The Lookup transformation can return one row or multiple rows from a lookup.

An unconnected Lookup transformation is a Lookup transformation that is not connected to a source or target in the mapping. Call the lookup with a :LKP expression in a transformation that allows expressions.

The syntax for the lookup expression is :LKP lookup_transformation_name(argument, argument, ...)