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 / ramesh

Hi,
actually normalizer tr act as a datapivoting.
datapivoting sense to generate the multiple records from a single record.

Is This Answer Correct ?    26 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to partition the Session?

638


What is the maplet?

612


In how many ways we can create ports?

695


What is repository manager?

528


WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com

1506






How many ways are there to create ports?

715


I have a flat file, want to reverse the contents of the flat file

682


Define update strategy?

627


What are the tuning techniques you applied during your last project

1553


Explain dynamic target flat file name generation in informatica

639


What is parallel processing in informatica?

1017


Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.

1859


Explain the code page compatibility?

632


How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?

1605


What is the difference between informatics 7x and 8x and what is latest version?

533