1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

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

Answers were Sorted based on User's Feedback



1)can anyone explain how to use Normalizer transformation for the following scenario Source tab..

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

1)can anyone explain how to use Normalizer transformation for the following scenario Source tab..

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

1)can anyone explain how to use Normalizer transformation for the following scenario Source tab..

Answer / sri

It is useful in combining all the multiple columns in to a
single column and viceversa.
Let me know if this is wrong.....!

Is This Answer Correct ?    1 Yes 1 No

1)can anyone explain how to use Normalizer transformation for the following scenario Source tab..

Answer / murthy

I'm not expert , actually i'm a new commer on datastage
i think this problem can be achieved by using pivot stage
because it converts the multiple columns data format in to
the multiple rows format, so i think it will be useful for u
thanks
murthy

Is This Answer Correct ?    0 Yes 1 No

1)can anyone explain how to use Normalizer transformation for the following scenario Source tab..

Answer / kishore

Hi,
according to my idea, take 3 different groups in the
normalizer transformation like....
1. stud_id studname
------- --------
1 Ramesh
2 Himesh
3 Mahesh

2. Sub_id Subname
------- -------
10 ENG
20 MAT
30 ART

3. sub_id stud_id marks
------ ------- -----
1 10 68
1 20 82
1 30 78
2 10 73
2 20 87
2 30 89
3 10 81
3 20 79
3 30 64
make sure that all these 3 groups have proper relationship
with each other.
finally map the appropriate fields to the target.

I'm not exactly sure about this answer but i would be
thankfull for any suggestions.

have a nice day. Kishore.

Is This Answer Correct ?    9 Yes 12 No

Post New Answer

More Informatica Interview Questions

Explain joiner transformation in informatica

0 Answers   Informatica,

Can we create out put ports in source qualifier t/r?

5 Answers   TCS,

How many ways you create ports?

1 Answers  

I want skip first 5 rows to load in to target? what will be the logic at session level ??

1 Answers   IBM,

what is data driven?

1 Answers  




Hi, If any hav Informatica n DWH FAQ's,Plz do fwd to vanibv6@gmail.com Thnx Vani

1 Answers  

What is the difference between Bulk Load and Normal Load

3 Answers   TCS,

Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?

0 Answers  

What is different between informatica version 8 and 9 version

1 Answers   Cognizant, IBM,

What are the different types of Type2 dimension maping?

2 Answers   CTS,

What is confirmed dimension?

3 Answers  

can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com

0 Answers   IBM,

For more Informatica Interview Questions Click Here
Categories