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
- 11199 Views
- HP, I also Faced
- E-Mail Answers
Answer Posted / raj
sourcequalifier....>normalizer.....>expression...>aggrgater....>target
| Is This Answer Correct ? | 8 Yes | 1 No |
Post New Answer View All Answers
How to generate sequence numbers without using the sequence generator transformation?
What are the components of workflow manager?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
What is intricate mapping?
What is the session task and command task?
What is an active transformation?
generate date / time dimension in informatica
What do you mean by worklet?
Whats the difference between informatica powercenter server, repositoryserver and repository?
How to differentiate between the active and passive transformations?
What is the difference between STOP and ABORT options in Workflow Monitor?
tell me 5 session failure in real time how can you solve that in your project?
Define the various join types of joiner transformation?
What are the designer tools for creating transformations?
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
