Table of Contents
- 1 How many types of transformation are there in Informatica?
- 2 What is the use of sorter transformation in Informatica?
- 3 Why do we use normalizer transformation?
- 4 What is the normalizer of a group?
- 5 What is a mapplet in Informatica?
- 6 Can we do ranking on two ports if yes explain how?
- 7 Can we convert rows to columns using normalizer?
- 8 What is deployment group in Informatica?
How many types of transformation are there in Informatica?
There are two types of transformations in Informatica that are active and passive.
What is the use of sorter transformation in Informatica?
Sorter transformation in Informatica is used to sort the data in an ascending or descending order based on single or multiple keys. This is the type an active transformation which sorts the data either in ascending order or descending order.
How do I convert multiple rows to single row in Informatica?
Solution:
- Create a new mapping.
- Drag the source into the mapping.
- Create an expression transformation.
- Drag the ports of source qualifier into the expression transformation.
- Create the below additional ports in the expression transformation and assign the corresponding expressions:
Why do we use normalizer transformation?
Normalizer is an active transformation, used to convert a single row into multiple rows and vice versa. It is a smart way of representing your data in more organized manner. In this case, the class score column is repeating in four columns. Using normalizer, we can split these in the following data set.
What is the normalizer of a group?
The normalizer (normaliser in British English) of a subgroup in a group is any of the following equivalent things: The largest intermediate subgroup in which the given subgroup is normal. The set of all elements in the group that commute with the subgroup.
Is update strategy an active transformation?
The Update Strategy Transformation in Informatica is an Active and Connected transformation. It is useful to update, insert, or delete the records in a target based on source table data. And the beauty of this transformation is: you can restrict the records from not reaching into the target table.
What is a mapplet in Informatica?
A mapplet is a reusable object containing a set of transformations that you can use in multiple mappings. Use a mapplet in a mapping. Or, validate the mapplet as a rule. Transformations in a mapplet can be reusable or non-reusable. If you add a Sequence Generator transformation to a mapplet, it must be reusable.
Can we do ranking on two ports if yes explain how?
No. We can specify to rank the data based on only one port.
What is incremental aggregation in Informatica?
When using incremental aggregation, you apply captured changes in the source to aggregate calculations in a session. If the source changes incrementally and you can capture changes, you can configure the session to process those changes.
Can we convert rows to columns using normalizer?
Normalizer is an active transformation, used to convert a single row into multiple rows and vice versa. It is a smart way of representing your data in more organized manner. In this case, the class score column is repeating in four columns….Normalizer Transformation in Informatica with EXAMPLE.
| Store Name | Quarter | Sales |
|---|---|---|
| DELHI | 1 | 150 |
| DELHI | 2 | 240 |
| DELHI | 3 | 455 |
| DELHI | 4 | 100 |
What is deployment group in Informatica?
Informatica Deployment Groups, simply put, act as containers that allow smart grouping of objects to facilitate the deployment between different folders, repositories and environments. They are objects themselves and they contain specific versioned objects selected for deployment from different source folders.