21.What are different types of transformations available in Informatica?
There are various types of transformations available in Informatica :
Aggregator
Application Source Qualifier Custom
Expression External Procedure Filter
Input Joiner Lookup Normalizer Output Rank Router
Sequence Generator Sorter
Source Qualifier Stored Procedure Transaction Control Union
Update Strategy XML Generator XML Parser
XML Source Qualifier
22.What are Aggregator Transformation?
Aggregator transformation is an Active and Connected transformation. This transformation is useful to perform calculations such as averages and sums (mainly to perform calculations on multiple rows or groups).
23.What are Expression transformation?
Expression transformation is a Passive and Connected transformation. This can be used to calculate values in a single row before writing to the target.
24.What are Filter transformation?
Filter transformation is an Active and Connected transformation. This can be used to filter rows in a mapping that do not meet the condition.
25.What are Joiner transformation?
Joiner Transformation is an Active and Connected transformation. This can be used to join two sources coming from two different locations or from same location.
26.Why we use lookup transformations?
Lookup Transformations can access data from relational tables that are not sources in mapping.
27.What are Normalizer transformation?
Normalizer Transformation is an Active and Connected transformation. It is used mainly with COBOL sources where most of the time data is stored in denormalized format. Also, Normalizer transformation can be used to create multiple rows from a single row of data.
28.What are Rank transformation?
Rank transformation is an Active and Connected transformation. It is used to select the top or bottom rank of data.
29.What are Router transformation?
Router transformationis an Active and Connected transformation. It is similar to filter transformation. The only difference is, filter transformation drops the data that do not meet the condition whereas router has an option to capture the data that do not meet the condition. It is useful to test multiple conditions.
30.What are Sorter transformation?
Sorter transformation is a Connected and an Active transformation. It allows to sort data either in ascending or descending order according to a specified field.
Share This :
There are various types of transformations available in Informatica :
Aggregator
Application Source Qualifier Custom
Expression External Procedure Filter
Input Joiner Lookup Normalizer Output Rank Router
Sequence Generator Sorter
Source Qualifier Stored Procedure Transaction Control Union
Update Strategy XML Generator XML Parser
XML Source Qualifier
22.What are Aggregator Transformation?
Aggregator transformation is an Active and Connected transformation. This transformation is useful to perform calculations such as averages and sums (mainly to perform calculations on multiple rows or groups).
23.What are Expression transformation?
Expression transformation is a Passive and Connected transformation. This can be used to calculate values in a single row before writing to the target.
24.What are Filter transformation?
Filter transformation is an Active and Connected transformation. This can be used to filter rows in a mapping that do not meet the condition.
25.What are Joiner transformation?
Joiner Transformation is an Active and Connected transformation. This can be used to join two sources coming from two different locations or from same location.
26.Why we use lookup transformations?
Lookup Transformations can access data from relational tables that are not sources in mapping.
27.What are Normalizer transformation?
Normalizer Transformation is an Active and Connected transformation. It is used mainly with COBOL sources where most of the time data is stored in denormalized format. Also, Normalizer transformation can be used to create multiple rows from a single row of data.
28.What are Rank transformation?
Rank transformation is an Active and Connected transformation. It is used to select the top or bottom rank of data.
29.What are Router transformation?
Router transformationis an Active and Connected transformation. It is similar to filter transformation. The only difference is, filter transformation drops the data that do not meet the condition whereas router has an option to capture the data that do not meet the condition. It is useful to test multiple conditions.
30.What are Sorter transformation?
Sorter transformation is a Connected and an Active transformation. It allows to sort data either in ascending or descending order according to a specified field.
0 comments:
Post a Comment