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 / dilip ingole

Answer Posted / dilip ingole

using query

SELECT 'JAN' AS MONTHS,SUM(JAN) FROM CALADERQUERY
UNION
SELECT 'FEB' AS MONTHS,SUM(FEB) FROM CALADERQUERY
UNION
SELECT 'MAR' AS MONTHS,SUM(MAR) FROM CALADERQUERY
UNION
SELECT 'APR' AS MONTHS,SUM(APR) FROM CALADERQUERY;

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the features of complex mapping?

649

Which means the first record should come as last record and last record should come as first record and load into the target file?

613

what is SDLC way of code development?

1564

What are the components of workflow manager?

590

what is the Default Source Option For Update Strategy Transformation?

759




What is option by which we can run all the sessions in a batch simultaneously?

667

Explain constraint based loading in informatica

663

What is the Rank index port in Rank transformation?

672

What are the different versions of informatica?

685

What is the need of etl tools?

615

How many dimensions are there in informatica?

630

What is a stored procedure transformation?

611

What are the conditions needed to improve the performance of informatica aggregator transformation?

585

Could you explain what is enterprise data warehouse?

559

Can we create a node as a gateway node and the same node can be assigned to a grid?

641