what is normalizer transformation?
- 4 Answers
- 6302 Views
- Wipro, I also Faced
- E-Mail Answers
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 a connected transformation?
How informatica process data means how informatica works?
What is an aggregator transformation? it is active why cant it be passive explain?
Is snow flake or star schema used? If star schema means why?
IN A MAPPING WHEN WE USE AGGRIGATER TRANSFORMATION WE WILL USE GROUP BY PORT. IF GROUPBY IS NOT SELECTED BY DEFAULT IT WILL TAKE ONLY THE LAST COLUMN WHY????
why we are using surogate key in real time give me explanation
What is joiner transformation?
What are the reusable transformations?
I have source data like this col1 col2 col3 5 3 8 6 2 9 7 1 10 and i want to get target as col1 col2 col3 5 1 8 6 2 9 7 3 10 which transformation i have to use and how?
What is the need of an ETL tool?
i have source in oracle 10g,oracle 8i how will u take the data from two sources
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
Teradata 
