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
- 11080 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 differs when we choose the sorted input for aggregator transformation?
What is exclusive and normal mode for repository services?
what is INFORMATICA TESTING process
Explain the types of transformations?
Explain target update override in informatica
Differentiate between source qualifier and filter transformation?
How to generate sequence numbers without using the sequence generator transformation?
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
What is the different lookup cache(s)?
What are the reusable transformations?
What are active and passive transformations?
What is data movement mode in Informatica and difference between them?
What are the restrictions of union transformation?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
What are pre and post-session shell commands?
