by using normalizer transformation we can convert rows to columns. s-

Converting Rows to columns
I have Relational source like his.
JAN FEB MAR APR
100 200 300 400
500 600 700 800
900 100 200 300

I need to convert these rows into columns to the targe.

MONTH TOTAL
JAN 1500
FEB 900
MAR 1200
APR 1500

Please experts help me

Question Posted / usha

5 Answers
11570 Views
HP, I also Faced
E-Mail Answers

Answer Posted / usha

by using normalizer transformation we can convert rows to
columns.

s-->SQ--->NRM-->Target

Is This Answer Correct ?

2 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?

1129

What is the meaning of up gradation of repository?

2052

What is a passive transformation?

1152

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

9896

explan ur project architecture?

2126

What is the function of union transformation?

1201

How does the aggregator transformation handle null values?

1192

Partition, what happens if the specified key range is shorter and longer

2550

What are data-driven sessions?

1259

The question was on time stamp. what is the difference between HH and HH24 when to use when.

2120

Mention a few design and development best practices for informatica?

1042

What is a difference between complete, stop and abort?

1123

Which are the different editions of informatica powercenter that are available?

1079

What is the scenario which compels informatica server to reject files?

1120

Do you find any difficulty while working with flat files as source and target?

1146