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

Answer Posted / kamleshmishra291

SQ->EXP->NRM->TGT

EXP :-- CREATE 4 OUTPUT PORTS
PORT1= 'JAN'
PORT2='FEB'
PORT3='MAR'
PORT4='APRIL'
AGGR :-- DRAG ALL PORTS FROM EXP AND CREATE 4 OUTPUT PORT
PORT5= SUM(JAN)
PORT6=SUM(FEB)
PORT7=SUM(MAR)
PORT8=SUM(APRIL)
NRM : CREATE 2 PORTS
MONTHS- OCCUR(4)- STRING
TOTAL- OCCUR(4)- NUMBER
CONNECT NRM OUTPUT PORT TO TGT

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com

1472

Mention a few design and development best practices for informatica?

571

What does role playing dimension mean?

634

Can we override a native sql query within informatica?

636

In how many ways we can create ports?

712




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

541

What is an Integration service in Informatica?

716

How to update a particular record in target with out running whole workflow?

1167

how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.

1266

how many types of dimensions are available in informatica?

569

How many input parameters can exist in an unconnected lookup?

1016

What you know about transaction control transformation?

566

What do you mean by enterprise data warehousing?

663

How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how

1143

tell me the rules and responsblites in our project(my project is development)

1512