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

In informatics server which files are created during the session rums?

639

list out all the transformations which use cache?

691

Why is sorter an active transformation?

667

what is INFORMATICA TESTING process

1844

What are the types of presistent cache in look up tr.

1551




What is aggregator transformation in informatica?

545

What is rank transformation?

581

What are the types of schemas we have in data warehouse and what are the difference between them?

525

What is informatica metadata and where is it stored?

591

What are Dimensional table?

619

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

742

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

812

explain abt ur project architecture?

1765

How many input parameters can exist in an unconnected lookup?

994

Scheduling properties,whats the default (sequential)

1468