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
- 11571 Views
- HP, I also Faced
- E-Mail Answers
Answer Posted / dev
hi Raj, plz explain, what we need to do in expression
transformation...
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the tasks that can be performed using sq?
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?
Explain direct and indirect flat file loading (source file type) - informatica
How to create the source and target database connections in server manager?
How can you validate all mappings in the repository simultaneously?
In warehouses how many schemas are there?
What is workflow? What are the components of workflow manager?
What is an aggregator transformation?
What are batches?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
What is update strategy transform?
What is the different lookup cache(s)?
What is a dimensional model?
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??
Explain the informatica workflow?
