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 informatica?
Can you use flat files in Mapplets.
In a scenario I have col1, col2, col3, under that 1,x,y, and 2,a,b and I want in this form col1, col2 and 1,x and 1,y and 2,a and 2,b, what is the procedure?
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
my source like dis 10,asd,2000 10,asd,2000 10,asd,2000 20,dsf,3000 20,dsf,3000 20,dsf,3000 like dis and my requirement is first record is inserted into first target and duplicates of first record is inserted into second target ...like dis way ...? how to achieve dis?
How can yoU create or import flat file definition in to the warehouse designer?
What is data caches/ index caches?
how to find the 5th highest salary form each department using 1.SQL Query 2. Informatica power center designer?
what is target load plan
How do you update the records with or without using update strategy?
What is the difference between warehouse key and surrogate key?
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process