Hi, actually normalizer tr act as a datapivoting. datapivoting sens

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.

Question Posted / ramesh

5 Answers
27614 Views
FCS, IBM, Satyam, TCS, I also Faced
E-Mail Answers

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

What is native users?

1146

What is InformaticaPowerCenter?

1128

Explain the difference between mapping parameter and mapping variable?

1033

What are the tuning techniques you applied during your last project

2020

hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you

9815

how tokens will generate?

2196

can u any challenge your project?

2029

Differentiate between sessions and batches?

1013

my source is junk data how will u remove that junk data by using unix please any one replay me

3699

What is the use of target designer?

1043

What is the use of source qualifier?

1120

what is unit testing?tell me proceedure

2219

explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?

2145

can you please explain me pre session and post session options?

7556

Explain dynamic target flat file name generation in informatica

1045