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
11417 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

Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?

1285

Explain what are the different types of transformation available in informatica.

1152

How to handle decimal places while importing a flatfile into informatica?

1192

What is resilience time?

1148

How to go to the older version for a mapping?

1100

What is native users?

1170

What do think which one is the better joiner or look up?

1204

Is it possible to define a single node as a Gateway node as well as worker node?

1123

What are the types of schemas we have in data warehouse.

963

How to call shell scripts from informatica?

1001

what is Active lock explain

2804

Where is metadata stored?

1117

What is powercenter on grid?

1179

What is aggregator transformation in informatica?

953

what is mean by complex business rule ?

2162