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
- 8 Answers
- 11306 Views
- HP, I also Faced
- E-Mail Answers
Answer Posted / chandra mouli
You will take Expression Transfermation.
In Expression Editon you can write lke this
sum(months) and group by month.
| Is This Answer Correct ? | 2 Yes | 5 No |
Post New Answer View All Answers
Enterprise data warehouse your projects phase by phase explain?
what is INFORMATICA TESTING process
What are the different options available for update strategy?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
Explain the aggregator transformation?
Separate from an archive server and a powerhouse?
how we can load rejected record's at run time?(not through bad files)
What is intricate mapping?
Please let me know how to make encryption and decryption with example?
Where are the source flat files kept before running the session?
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
How to improve the performance of a session using sorter transformation?
What is domain in terms of informatica?
Informatica Checkpoints
What is lookup change?
