Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 5 Answers
- 11439 Views
- HP, I also Faced
- E-Mail Answers
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
What is decode in informatica?
What is rank index in rank transformation?
What is the advantage of informatica?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
Explain constraint based loading in informatica
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
Write the program through which the records can be updated?
What are the modules in Power Center
Explain about Informatica server process that how it works relates to mapping variables?
What are the differences between joiner transformation and source qualifier transformation?
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
How to create Target definition for flat files?
can anyone explain me about retail domain project in informatica?
What is the difference between writing a joiner query in ANSI style and THETA style?
Whats the difference between informatica powercenter server, repositoryserver and repository?
