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

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

Answer Posted / raj

sourcequalifier....>normalizer.....>expression...>aggrgater....>target

Is This Answer Correct ?    8 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can you generate sequence numbers without using the sequence generator transformation?

607

What are the types of data warehouses?

956

Can you use flat files in Mapplets.

2233

What are session parameters ? How do you set them?

1391

What is mapplet in informatica?

604




What is a mapplet/worklet in informatica?

697

What is meant by target load plan?

571

Implementation methodology

1270

While migrating the data from one environment to another environment how would you manage the connections?

632

how to load dimension table and fact table. plz tell me the steps.

1694

What is an unconnected transformation?

674

Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?

642

How do you take back up of repository?

732

Difference between Data and Index Caches?

666

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

541