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

What is the use of an aggregator cache file?

681

What is flashback table ? Advance thanks

1476

waht type of interface is used for testing the data in informatica

1828

What happens when a session fails and you click on recover?

651

Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?

546




What is main use of mapplet?

654

permutations of mapplet

2032

Why update strategy and union transformations are active?

589

Does an informatica transformation support only aggregate expressions?

604

what are 3 tech challenges/ common issues you face?

1882

What is an active transformation?

643

What is a transaction control transformation?

761

What are the reusable transformations?

692

What are connected or unconnected transformations?

622

How we can use union transformation?

605