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
What is domain in terms of informatica?
wat are deployement groups in informatica, how it will be used for developers
What are mapplets? How is it different from a Reusable Transformation?
Explain the mapping variable usage example in informatica
Please let me know how to make encryption and decryption with example?
What is mapplet in informatica?
How do you load only null records into target?
is it possible to index the data in cache of lkp transformation ?
What is dimensional table?
What do you understand by a term domain?
Plz can any one say me how to get the informatica certification materials and dumps
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
What are the differences between source qualifier and joiner transformation?
What is the sql query overwrite in source qualifier in informatica
How to load data in informatica ?