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 / 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 is the need for an etl tool?
What do you mean by filter transformation?
What is decode in static cache?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
What is blocking transformation?
wf dont have integration severances how you can run?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
Name the different lookup cache(s)?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
What's the layout of parameter file (what does a parameter file contain?)?
Explain in detail scd type 2 through mapping.
Where is metadata stored?
Define Pmrep command?