Informatica Transformations are repository objects which may create, read, modifies, or passes data to the defined target structures like tables, files, or the other targets.

In Informatica, the aim of transformation is to switch the source data consistent with the need of the target system. It also ensures the standard of the data being loaded into the target.

A Transformation is employed to represent a group of rules, which define the dataflow and the way the data is loaded into the targets.

Informatica provides multiple transformations to perform specific functionalities.

In transformations, to passing the data, we’d like to attach the ports there to, and thru the output ports, it returns the output.

Classification of Transformation

Transformation is assessed into two categories-the first one supported connectivity and second supported the change in several rows. First, we’ll check out the transformation supported connectivity.

Here are two sorts of transformation supported connectivity, such as:

Connected Transformations
Unconnected Transformations

In Informatica, one transformation is connected to other transformations during mappings are called connected transformations.

For example, Source qualifier transformation of Source table Stud is connected to filter transformation to filter students of a category.

Those transformations whose not link to the other transformations are called unconnected transformations.

Their functionality is employed by calling them inside other transformations. And these transformations aren’t a part of the pipeline.

The connected transformations are preferred when the transformation is named for each input row or expected to return a worth.

The unconnected transformations are useful if their functionality is required periodically only or based upon certain conditions. for instance, calculate the tax details if tax value isn’t available.

Here are two sorts of transformations supported the change in several rows, such as:

Active Transformations
Passive Transformations

Active Transformations are those that modify the data rows, and therefore the number of input rows passed to them. for instance , if a change receives 10 numbers of rows as input, and it returns 15 numbers of rows as an output, then it’s a lively transformation. within the active transformation, the data is modified within the row.

Passive Transformations don’t change the amount of input rows. In passive transformations, the amount of input and output rows remains an equivalent , and data is modified at row level only.

In the passive transformation, we cannot create new rows, and no existing rows dropped.

List of Transformations in Informatica

Source Qualifier Transformation
Aggregator Transformation
Router Transformation
Joiner transformation
Rank Transformation
Sequence Generator Transformation
Transaction Control Transformation
Lookup and Re-usable transformation
Normalizer Transformation
Performance Tuning for Transformation
External Transformation
Expression Transformation

What is Filter Transformation?

Filter Transformation is a lively transformation because it changes the amount of records. we will filter the records consistent with the wants by using the filter condition.

For example, for loading the scholar records having rollno adequate to 20 only, we will put filter transformation within the mapping with the filter condition rollno=20. So only those records which have rollno =20 are going to be gone by filter transformation, rest other records are going to be dropped.

Step 1: Create a mapping having source “Stu” and target “Stu_target”.

Step 2: Then within the mapping

Select Transformation menu
Select the create option.

Step 3: within the create transformation window

Select Filter Transformation from the list.
Enter Transformation name fltr_rollno_20
Select create option

Step 4: The filter transformation are going to be created, click on the Done button within the creative transformation window.

Step 5: within the mapping,

Drag and drop all the source qualifier columns from the filter transformation.
And Link the columns of filter transformation to the target table.

Step 6: Double click on the filter transformation to open its properties, and

Select the properties menu.
Click on the filter condition editor.

Step 7: Then,

Enter filter condition rollno=20.
Click on the OK button.

Step 8: Again within the edit transformation window,

we’ll see the filter condition within the properties tab.
Click on the OK button.

Now save the created mapping and execute this after creating session and workflow. within the target table, only the rollno = 20 are going to be loaded from the record.

So, this brings us to the end of blog. This Tecklearn ‘Informatica Transformations’ blog helps you with commonly asked questions if you are looking out for a job in Informatica. If you wish to learn Informatica and build a career in Datawarehouse and ETL domain, then check out our interactive, Informatica Training, that comes with 24*7 support to guide you throughout your learning period. Please find the link for course details:

https://www.tecklearn.com/course/informatica-training-and-certification/

Informatica Training

About the Course

Tecklearn’s Informatica Training will help you master Data Integration concepts such as ETL and Data Mining using Informatica PowerCenter. It will also make you proficient in Advanced Transformations, Informatica Architecture, Data Migration, Performance Tuning, Installation & Configuration of Informatica PowerCenter. You will get trained in Workflow Informatica, data warehousing, Repository Management and other processes.

Why Should you take Informatica Training?

Informatica professionals earn up to $130,000 per year – Indeed.com
GE, eBay, PayPal, FedEx, EMC, Siemens, BNY Mellon & other top Fortune 500 companies use Informatica.
Key advantages of Informatica PowerCenter: Excellent GUI interfaces for Administration, ETL Design, Job Scheduling, Session monitoring, Debugging, etc.

What you will Learn in this Course?

Informatica PowerCenter 10 – An Overview

Informatica & Informatica Product Suite
Informatica PowerCenter as ETL Tool
Informatica PowerCenter Architecture
Component-based development techniques

Data Integration and Data Warehousing Fundamentals

Data Integration Concepts
Data Profile and Data Quality Management
ETL and ETL architecture
Brief on Data Warehousing

Informatica Installation and Configuration

Configuring the Informatica tool
How to install the Informatica operational administration activities and integration services

Informatica PowerCenter Transformations

Visualize PowerCenter Client Tools
Data Flow
Create and Execute Mapping
Transformations and their usage
Hands On

Informatica PowerCenter Tasks & Workflows

Informatica PowerCenter Workflow Manager
Reusability and Scheduling in Workflow Manager
Workflow Task and job handling
Flow within a Workflow
Components of Workflow Monitor

Advanced Transformations

Look Up Transformation
Active and Passive Transformation
Joiner Transformation
Types of Caches
Hands On

More Advanced Transformations – SQL (Pre-SQL and Post-SQL)

Load Types – Bulk, Normal
Reusable and Non-Reusable Sessions
Categories for Transformation
Various Types of Transformation – Filter, Expression, Update Strategy, Sorter, Router, XML, HTTP, Transaction Control

Various Types of Transformation – Rank, Union, Stored Procedure

Error Handling and Recovery in Informatica
High Availability and Failover in Informatica
Best Practices in Informatica
Debugger
Performance Tuning

Performance Tuning, Design Principles & Caches

Performance Tuning Methodology
Mapping design tips & tricks
Caching & Memory Optimization
Partition & Pushdown Optimization
Design Principles & Best Practices

Informatica PowerCenter Repository Management

Repository Manager tool (functionalities, create and delete, migrate components)
PowerCenter Repository Maintenance

Informatica Administration & Security

Features of PowerCenter 10
Overview of the PowerCenter Administration Console
Integration and repository service properties
Services in the Administration Console (services, handle locks)
Users and groups

Command Line Utilities

Infacmd, infasetup, pmcmd, pmrep
Automate tasks via command-line programs

More Advanced Transformations – XML

Java Transformation
HTTP Transformation

Got a question for us? Please mention it in the comments section and we will get back to you.

479