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
Answer Posted / siva
Please Explain me briefly. Thank You.
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
How can we update a record in the target table without using update strategy?
What is dimensional table? Explain the different dimensions.
4 yrs etl devloper roles and responsibilities?any body give solutions
Define joiner transformation?
What is Data Caches size?
What is repository manager?
Explain what transformation and how many are there in informatica?
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?
Under which circumstances, informatica server creates reject files?
can anyone explain me about retail domain project in informatica?
What is the difference between a connected look up and unconnected lookup?
What are the types of lookup transformation?
How to generate or load values in to the target table based on a column value using informatica etl tool.
Can we create multiple integration service on single repository?
What do you mean by channel change?