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
- 11089 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 session parameters ? How do you set them?
What is a snowflake schema?
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
What's the layout of parameter file (what does a parameter file contain?)?
How would you copy the content of one repository to another repository?
Differences between connected and unconnected lookup?
How are the sources and targets definitions imported in informatica designer?
What is decode in informatica?
What is xml source qualifier transformation in informatica?
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
EXL informatica Questions
tell me 5 session failure in real time how can you solve that in your project?
explain about unit testing? in real time?
Performance tuning( what you did in performance tuning)
What is meant by incremental aggregation?
