what is normalizer transformation?
Answers were Sorted based on User's Feedback
Answer / mike
sorry... there was a correction...Normalizer is an active
connected transformation...
| Is This Answer Correct ? | 6 Yes | 0 No |
Answer / sbvp
it is used to import cobol files . and it acts like a
default sq for retrieving cobol sources. and main advantage
from normalizer is to do a data pivoting.
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / mike
It is a passive connected transformation which is used to
extract dat from cobol source. By using normalizer
transformation we can create multiple outputs from a single
input this is called PIVOT
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / sankar
this is type an active t/r which allows to read the data
from cobol sources, normalizer t/r acts like a source
qualifier while reading the data from cobol source.
this is converting a single input record into multiple
records
| Is This Answer Correct ? | 3 Yes | 0 No |
What is sorter transformation?
What are the differences between source qualifier and joiner transformation?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
Is it possible to define a single node as a Gateway node as well as worker node?
i have a table like empid ename year month sal 1 x 98 jan 500 1 x 98 feb 500 1 x 98 mar 500 1 x 99 jan 600 1 x 99 feb 600 2 y 98 jan 600 2 y 98 feb 600 2 y 98 mar 600 2 y 99 jan 700 2 y 99 jan 700 and so on i want to find out totsal for every emp on year wise plz help me
Want to know about Training Centres for Informatica, Cognos and ETL Softwares in Mumbai, India.
wht target override?wht advantages it has compare to target update?
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
How to list Top 10 salary, without using Rank Transmission?
How to eliminate duplicate records in informatica mapping? Explain with an example....
Lookup transformation, one condition is having SQL override (Empno < 10) and the other condition is Lookup (Sal>1000), which is dynamic. How will u resolve this situation?