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 hash partition?
following table source target name gender name target a1 male a1 female a2 female a2 male i want a1 female update to target how will do?
How do you load first and last records into target table?
without update strategy how to insert &update?
Can we call a stored procedure from a unix script which is run using command task
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
what are the transformations that are used in data cleansing ? and how data cleansing takes place ?
i have 2 mapings for this 2 mapings i want use only one lookupt/r how?
Can we use the mapping parameters or variables created in one mapping into another mapping?
What is tracing level and what are the types of tracing level?
What is a snowflake schema?
Suppose i have 10000 records.First time i have to load 1 to 1000 records and second run i have load 1000 to 2000 records and third load i have to load 2000 to 3000 rows .How will achieve