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
- 8842 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
What is olap (on-line analytical processing?
What is data caches/ index caches?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
What are the performance considerations when working with aggregator transformation?
How an expression transformation differs from aggregator transformation?
Define mapplet?
How to join three sources using joiner?
Explain the tuning lookup transformation - informatica
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
What is meant by a domain?
Define filter transformation?
Explain pushdown optimization $pushdownconfig parameter - informatica
What is a dimensional model?
-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?
State the differences between sql override and lookup override?
