hi,there is a scenario like.
there are three columns empid,salmonth, sal contains the values 101,jan,1000
101 feb 1000 like twelve rows are there then my required out put is like
contains 13 columns empid jan feb marc.......dec and the velues are
101 1000 1000 1000 like this . thank you
Answer Posted / veeru
Use DECODE FUNCTION you can get answer.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Differentiate between joiner and lookup transformation?
What is expression transformation?
How to improve the performance of a session using sorter transformation?
Explain the informatica workflow?
What is the meaning of up gradation of repository?
In warehouses how many schemas are there?
can u any challenge your project?
What are the new features of informatica 9.x developer?
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
How to do unit testing in informatica? How to load data in informatica ?
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?
How to create a non-reusable instance of reusable transformations?
When do you use sql override in a lookup transformation?
What does refresh system mean, and what are its distinctive choice?
Write the unconnected lookup syntax and how to return more than one column.