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

Answer Posted / siva

Please Explain me briefly. Thank You.

Is This Answer Correct ?    1 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is an Integration service in Informatica?

690

What is powercenter on grid?

680

How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?

700

SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N

1670

Can we change Dynamic to Static or Persistent cache? If so what happens?

1706




What are ETL Tools?

653

Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?

7747

What if the source is a flat-file?

575

Define joiner transformation?

580

What is the surrogate key?

619

what are 3 tech challenges/ common issues you face?

1873

What is aggregator transformation in informatica?

530

Plz can any one say me how to get the informatica certification materials and dumps

1583

Tell me any other tools for scheduling purpose other than workflow manager pmcmd?

694

what are factless facts? And in which scenario will you use such kinds of fact tables.

1296