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
- 10750 Views
- HP, I also Faced
- E-Mail Answers
Answer Posted / chandu621
you will take Expression transfermation
and write expression like this
sum(months)
| Is This Answer Correct ? | 0 Yes | 7 No |
Post New Answer View All Answers
What are the differences between joiner transformation and source qualifier transformation?
How many ways are there to create ports?
Explain the shared cache and re-cache?
What is the procedure for creating independent data marts from informatica 7.1?
What is workflow manager?
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
What is a filter transformation?
scenario where i can use only concurrent execution of workflow.
Why sorter is an active transformation?
what is the -ve test case in your project.
write a query to retrieve the latest records from the table sorted by version(scd)
How you know when to use a static cache and dynamic cache in lookup transformation?
Is it possible to use a client with different version than that of its Informatica server?
explain abt ur project architecture?
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
