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

Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?

742

If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?

8587

What is primary and backup node?

714

If informatica has its scheduler why using third party scheduler?

795

What are the measure objects?

677




what is the Default Source Option For Update Strategy Transformation?

768

During the running session, output files are created by informatica server. Enlist few of them.

550

What is meant by lookup transformation?

621

Does an informatica transformation support only aggregate expressions?

618

What are the tasks that source qualifier perform?

639

Write the program through which the records can be updated?

528

Which is the t/r that builts only single cache memory?

725

What is persistent lookup cache?

613

How to extract sap data using informatica?

616

what is unit testing?tell me proceedure

1794