1)can anyone explain how to use Normalizer transformation
for the following scenario
Source table | Target Table
|
Std_name ENG MAT ART | Subject Ramesh Himesh Mahesh
Ramesh 68 82 78 | ENG 68 73 81
Himesh 73 87 89 | MAT 82 87 79
Mahesh 81 79 64 | ART 78 89 64
|
please explain what should be
the normalizer column(s)
The GCID column
2)Also please explain the Ni-or-1 rule.
Answer Posted / karthik
Normalizer transformation mainly used for changing the multiple record into a slngle row.
where as in this transformation rows converted into columns and columns to rows.
for more understanding.....
source table target table
eng mat | A B C D E F G
A 88 90 |
B 11 22 | ENG 88 11 44 77 88 88 96
C 44 85 | MAT 90 22 85 85 66 88 69
D 77 85 |
E 88 66
F 88 88
G 96 69
MOSTLY WE CANT USE THIS TRANSFORMATION IN THE PROJECTS
Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
How would you join a node to the already existing domain?
What is mapping debugger?
What are the main features of Oracle 8i with context to datawarehouse?
what is $$$$?
How we can create indexes after completing the loan process?
What is InformaticaPowerCenter?
What is dynamic cache?
Explain transaction control transformation in informatica
Why filter transformation is an active one?
How do you set a varible in incremental aggregation
What is rank index in rank transformation?
What is workflow? What are the components of workflow manager?
Which transformation is needed while using the Cobol sources as source definitions?
What are the different options available for update strategy?