Introduction to Transformations in Informatica and Filter Transformation - Shikshaglobe

Content Creator: Vijay Kumar

What is Transformation?

Transformations in Informatica are the objects which create, modify or pass data to the defined target structures (tables, files, or any other target).

The purpose of the transformation in Informatica is to modify the source data as per the requirement of the target system. It also ensures the quality of the data being loaded into the target.

Informatica provides various transformations to perform specific functionalities.

For example, performing tax calculations based upon source data, data cleansing operations, etc. In transformations, we connect the ports to pass data to it, and transformation returns the output through output ports.


Classification of Transformation

Transformation is classified into two categories, one based on connectivity, and the other based on the change in the of rows. First, we will look at the transformation based on connectivity.

Types of transformation based on connectivity

Connected Transformations

Unconnected Transformations

In Informatica, during mappings, the transformations which are connected to other transformations are called connected transformations.

For example, Source qualifier transformation of Source table EMP is connected to filter transformation to filter employees of a dept.

Those transformations that are not connected to any other transformations are called unconnected transformations.

Their functionality is used by calling them inside other transformations like Expression transformation. These transformations are not part of the pipeline.

The connected transformations are preferred when for every input row, a transformation is called or is expected to return a value. For example, for the zip codes in every row, the transformation returns the city name.


The unconnected transformations are useful when their functionality is only required periodically or based upon certain conditions. For example, calculate the tax details if the tax value is not available.

Types of transformations based on the change in the rows

Active Transformations

Passive Transformations

Active Transformations are those that modify the data rows and the number of input rows passed to them. For example, if a transformation receives ten rows as input, and it returns fifteen rows as an output then it is an active transformation. The data in the row is also modified in the active transformation.


Passive transformations are those that do not change the number of input rows. In passive transformations the number of input and output rows remain the same, only data is modified at row level.

In the passive transformation, no new rows are created, or existing rows are dropped.

Following is the 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 an active transformation as it changes the no of records.


Using the filter transformation, we can filter the records based on the filter condition. Filter transformation is an active transformation as it changes the no of records.

For example, for loading the employee records having deptno equal to 10 only, we can put filter transformation in the mapping with the filter condition deptno=10. So only those records which have deptno =10 will be passed by filter transformation, the rest other records will be dropped.


How to use filter transformation-

Step 1 – Create a mapping having source “EMP” and target “EMP_TARGET”

Step 2 – Then in the mapping


Select Transformation menu

Step 3 – Then in the creative transformation window


Select Filter Transformation from the list

Enter Transformation name “fltr_deptno_10”

Step 4 – The filter transformation will be created, select the “Done” button in the creative transformation window

Step 5 – In the mapping

Drag and drop all the Source qualifier columns to the filter transformation

Link the columns from filter transformation to the target table


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


Select the properties menu

Click on the Filter condition editor


Step 7 – Then in the filter condition expression editor

Enter filter condition – deptno=10

Select OK button


Step 8 – Now again in the edit transformation window in the Properties tab you will see the filter condition, select the OK button

Now save the mapping and execute it after creating the session and workflow. In the target table, the records having deptno=10 only will be loaded.

In this way, you can filter the source records using filter transformation.

Tags:

transformations in informatica and filter transformationtransformations in informatica and filter transformation architecturetransformations in informatica and filter transformation are the sametransformations in informatica and filter transformation at same timetransformations in informatica and filter transformation and queriestransformations in informatica and filter transformation arttransformations in informatica and filter transformation alliancetransformations in informatica and filter transformation apptransformations in informatica and filter transformation active or passivetransformations in informatica and filter transformation best practicestransformations in informatica and filter transformation based on conditiontransformations in informatica and filter transformation before and aftertransformations in informatica and filter transformation biologytransformations in informatica and filter transformation biology definitiontransformations in informatica and filter transformation bdmtransformations in informatica and filter transformation between routertransformations in informatica and filter transformation between expressiontransformations in informatica and filter transformation connectionstransformations in informatica and filter transformation codetransformations in informatica and filter transformation commandtransformations in informatica and filter transformation command linetransformations in informatica and filter transformation conditiontransformations in informatica and filter transformation condition examplestransformations in informatica and filter transformation case sensitivetransformations in informatica and filter transformation cachetransformations in informatica and filter transformation centertransformations in informatica and filter transformation differencetransformations in informatica and filter transformation datatransformations in informatica and filter transformation diagramtransformations in informatica and filter transformation definitiontransformations in informatica and filter transformation deviantarttransformations in informatica and filter transformation diettransformations in informatica and filter transformation datetransformations in informatica and filter transformation detail outer jointransformations in informatica and filter transformation developertransformations in informatica and filter transformation data qualitytransformations in informatica and filter transformation exampletransformations in informatica and filter transformation einstein analyticstransformations in informatica and filter transformation errortransformations in informatica and filter transformation expressiontransformations in informatica and filter transformation for datatransformations in informatica and filter transformation for multiple columnstransformations in informatica and filter transformation for different tablestransformations in informatica and filter transformation for each rowtransformations in informatica and filter transformation for each columntransformations in informatica and filter transformation femaletransformations in informatica and filter transformation fanfictiontransformations in informatica and filter transformation fitnesstransformations in informatica and filter transformation falsetransformations in informatica and filter transformation folks talktransformations in informatica and filter transformation guidetransformations in informatica and filter transformation grouptransformations in informatica and filter transformation gridtransformations in informatica and filter transformation graphqltransformations in informatica and filter transformation giftransformations in informatica and filter transformation giventransformations in informatica and filter transformation geometrytransformations in informatica and filter transformation guru99transformations in informatica and filter transformation gatewaytransformations in informatica and filter transformation helptransformations in informatica and filter transformation hanatransformations in informatica and filter transformation howtransformations in informatica and filter transformation hubtransformations in informatica and filter transformation hubspottransformations in informatica and filter transformation in informaticatransformations in informatica and filter transformation in ssistransformations in informatica and filter transformation interview questionstransformations in informatica and filter transformation is not nulltransformations in informatica and filter transformation input is not sortedtransformations in informatica and filter transformation is case sensitivetransformations in informatica and filter transformation idqtransformations in informatica and filter transformation inputtransformations in informatica and filter transformation iicstransformations in informatica and filter transformation if conditiontransformations in informatica and filter transformation jobstransformations in informatica and filter transformation jmetertransformations in informatica and filter transformation javatransformations in informatica and filter transformation jointransformations in informatica and filter transformation join typetransformations in informatica and filter transformation kittransformations in informatica and filter transformation keystransformations in informatica and filter transformation khan academytransformations in informatica and filter transformation kit reviewstransformations in informatica and filter transformation kit costtransformations in informatica and filter transformation librarytransformations in informatica and filter transformation listtransformations in informatica and filter transformation languagetransformations in informatica and filter transformation linetransformations in informatica and filter transformation liketransformations in informatica and filter transformation love is a battlefieldtransformations in informatica and filter transformation labtransformations in informatica and filter transformation lab answerstransformations in informatica and filter transformation left jointransformations in informatica and filter transformation limitationstransformations in informatica and filter transformation matrixtransformations in informatica and filter transformation mappingtransformations in informatica and filter transformation managertransformations in informatica and filter transformation matlabtransformations in informatica and filter transformation multiple conditionstransformations in informatica and filter transformation multiple valuestransformations in informatica and filter transformation multiple tablestransformations in informatica and filter transformation master outer jointransformations in informatica and filter transformation not workingtransformations in informatica and filter transformation nametransformations in informatica and filter transformation networktransformations in informatica and filter transformation network mansfield ohiotransformations in informatica and filter transformation network ashland ohiotransformations in informatica and filter transformation not nulltransformations in informatica and filter transformation nottransformations in informatica and filter transformation null valuestransformations in informatica and filter transformation not sortedtransformations in informatica and filter transformation oracletransformations in informatica and filter transformation of functionstransformations in informatica and filter transformation outer jointransformations in informatica and filter transformation or passivetransformations in informatica and filter transformation operatortransformations in informatica and filter transformation or conditiontransformations in informatica and filter transformation pdftransformations in informatica and filter transformation practicetransformations in informatica and filter transformation performancetransformations in informatica and filter transformation power bitransformations in informatica and filter transformation performance tuningtransformations in informatica and filter transformation propertiestransformations in informatica and filter transformation parametertransformations in informatica and filter transformation power centertransformations in informatica and filter transformation portstransformations in informatica and filter transformation querytransformations in informatica and filter transformation questionstransformations in informatica and filter transformation quizlettransformations in informatica and filter transformation query resultstransformations in informatica and filter transformation queuetransformations in informatica and filter transformation quotestransformations in informatica and filter transformation qualitytransformations in informatica and filter transformation relationshiptransformations in informatica and filter transformation resultstransformations in informatica and filter transformation rulestransformations in informatica and filter transformation reporttransformations in informatica and filter transformation resumetransformations in informatica and filter transformation reddittransformations in informatica and filter transformation reviewstransformations in informatica and filter transformation routertransformations in informatica and filter transformation stepstransformations in informatica and filter transformation syntaxtransformations in informatica and filter transformation same tabletransformations in informatica and filter transformation same querytransformations in informatica and filter transformation scenariostransformations in informatica and filter transformation scopetransformations in informatica and filter transformation sorted inputtransformations in informatica and filter transformation sensitivetransformations in informatica and filter transformation sortertransformations in informatica and filter transformation sortedtransformations in informatica and filter transformation tutorialtransformations in informatica and filter transformation togethertransformations in informatica and filter transformation tabletransformations in informatica and filter transformation tooltransformations in informatica and filter transformation teamtransformations in informatica and filter transformation tuesdaytransformations in informatica and filter transformation typestransformations in informatica and filter transformation tutorial gatewaytransformations in informatica and filter transformation tuningtransformations in informatica and filter transformation talktransformations in informatica and filter transformation usingtransformations in informatica and filter transformation using power querytransformations in informatica and filter transformation using power bitransformations in informatica and filter transformation using power automatetransformations in informatica and filter transformation uniontransformations in informatica and filter transformation valuestransformations in informatica and filter transformation viewstransformations in informatica and filter transformation via querytransformations in informatica and filter transformation videotransformations in informatica and filter transformation vs routertransformations in informatica and filter transformation with exampletransformations in informatica and filter transformation workflowtransformations in informatica and filter transformation with different columnstransformations in informatica and filter transformation worksheettransformations in informatica and filter transformation workouttransformations in informatica and filter transformation workout plantransformations in informatica and filter transformation workingtransformations in informatica and filter transformation xmltransformations in informatica and filter transformation xml filetransformations in informatica and filter transformation xml datatransformations in informatica and filter transformation xenoverse 2transformations in informatica and filter transformation youtubetransformations in informatica and filter transformation youtube video