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.

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

who to split dimentions into sub dimention

3 Answers   Wipro,


If source is having 5000 rows,and if you want to load data into 500 rows to target,if the session runs successfully,how can you verify the target if the rows are successfully loaded or not.

3 Answers   IBM, TCS,


difference between stop and abort

2 Answers  


What is A cache?

2 Answers  


Can informatica load heterogeneous targets from heterogeneous sources?

0 Answers  






How to load last 10 records of flat file in to the target?

5 Answers   iNautix,


Scenario:-  Below is the requirement. Source:-  NAME          ID                    Requirement  RAVI            1                      (no need to repeat as it ID is 1) KUMAR        3                     (repeat 3 times as it ID is 3) John             4                     (repeat 4 times as it ID is 4) Required Out Put:- Name                   ID RAVI                     1                    KUMAR                3      KUMAR                3 KUMAR                3  John                     4 John                     4 John                     4 John                     4 Scenario 2:- Source Data  ID              NAME 1,2            NETEZZA,ORACLE 3,4,5         SQL Server, DB2, Teradata Required Output:-  ID                   NAME 1                  NETEZZA 1                  ORACLE 3                  SQL Server 3                  DB2 3                  Teradata

1 Answers   Cognizant,


How can a transformation be made reusable?

0 Answers   Informatica,


How to load last n records of file into target table - informatica

0 Answers   Informatica,


how to use incremental load?

2 Answers   TCS,


Under what condition selecting sorted input in aggregator may fail the session?

0 Answers  


HOw can we load the normalised data ( Vertical data) to (Horizontal data)with out using decode in the expression transformation and the aggregator transformation. But, what exactly I want is .. If we have million of records,it is not possible using decode and search for that Particular Id to pivot into Horizontal data... Can any one of guys please help me in this regard.....

3 Answers   TCS,


Categories