Answer Posted / rao
normalizer transformation.which will performs normalized data.
ex:year q1 q2 q3
2006 10 20 30
2007 20 30 40
after performing the normalizer transformation the date
will be like this
year item sales
2006 1 10
2006 2 20
2006 3 30
like 2007 also
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
How are the sources and targets definitions imported in informatica designer?
How might you approve all mappings in the archive all the while?
Where are the source flat files kept before running the session?
Explain incremental aggregation in informatica
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
design of staging area?
How to extract sap data using informatica? What is abap? What are idocs?
What are the popular informatica products?
What are mapplets? How is it different from a Reusable Transformation?
Explain the etl program with few examples.
What are data-driven sessions?
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
How do you update the records with or without using update strategy?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?