What Is Transformation in Informatica and What it Does ?
If you just started learning informatica for ETL work then first thing you should know is Transformation.
In Informatica a transformation can be repository object that will generate, modify, or forward data to other sources.
In simple words you can say that it will transform the source data into target data according to the requirements of target system by applying some rules.
Consider the above example , in this screenshot a basic transformation is shown. Here records from two different oracle tables are retrived and then using their department id both tables are joined in source qualifier transformation by applying simple expression. As a result in the target table we will get record whose department is same.
Types Of Transformation In Informatica
For example, if we are applying filter transformation on source then it will pass only those records which follows filter pattern, it simply reject other records. so no of records in target table will be less than source table. Filter transformation is Active transformation .
What Is Passive Transformations In Informatica ?
Comparing to active transformation, a passive transformation does not change the number of rows that pass through the transformation, maintains the transaction boundary, and maintains the row type.
For example, if you are applying expression transformation with expression +10, then this transformation will add numeric value 10 to all the record who passes through this port. so no of records in target table will be same as source table . Expression transformation is Passive Transformations.
What is Connected Transformations In Informatica ?
Connected transformation are those transformation which take part in data flow. Connected transformation has some input ports from which data will input from previous data flow and has some output port, from which data will be passed to next connected data flow. In the Default SQL join example all three objects are connected to each other.
What is Unonnected Transformations In Informatica ?
An unconnected transformation is not connected to other transformations in the mapping or data flow. An unconnected transformation is called within another transformation as a function call, and returns a value to that transformation.
for example Unconnected lookup is a type on Unonnected Transformation
in the next post i will explain how to create Transformation in Informatica.
If you just started learning informatica for ETL work then first thing you should know is Transformation.
In Informatica a transformation can be repository object that will generate, modify, or forward data to other sources.
In simple words you can say that it will transform the source data into target data according to the requirements of target system by applying some rules.
In Picture Default SQL Join Using Source Qualifier Transformation
Consider the above example , in this screenshot a basic transformation is shown. Here records from two different oracle tables are retrived and then using their department id both tables are joined in source qualifier transformation by applying simple expression. As a result in the target table we will get record whose department is same.
Types Of Transformation In Informatica
- Transformations can be active or passive according to no of records they produce in target table.
- Transformations can be connected to the data flow, or they can be unconnected.
What Is Active Transformation In Informatica ?
Basically An active transformation can Change the number of rows that pass through the transformation.It also Change the transaction boundary.For example, if we are applying filter transformation on source then it will pass only those records which follows filter pattern, it simply reject other records. so no of records in target table will be less than source table. Filter transformation is Active transformation .
What Is Passive Transformations In Informatica ?
Comparing to active transformation, a passive transformation does not change the number of rows that pass through the transformation, maintains the transaction boundary, and maintains the row type.
For example, if you are applying expression transformation with expression +10, then this transformation will add numeric value 10 to all the record who passes through this port. so no of records in target table will be same as source table . Expression transformation is Passive Transformations.
What is Connected Transformations In Informatica ?
Connected transformation are those transformation which take part in data flow. Connected transformation has some input ports from which data will input from previous data flow and has some output port, from which data will be passed to next connected data flow. In the Default SQL join example all three objects are connected to each other.
What is Unonnected Transformations In Informatica ?
An unconnected transformation is not connected to other transformations in the mapping or data flow. An unconnected transformation is called within another transformation as a function call, and returns a value to that transformation.
for example Unconnected lookup is a type on Unonnected Transformation
in the next post i will explain how to create Transformation in Informatica.
0 comments:
Post a Comment