Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

What is domain in terms of informatica?

957


wat are deployement groups in informatica, how it will be used for developers

1670


What are mapplets? How is it different from a Reusable Transformation?

1034


Explain the mapping variable usage example in informatica

1087


Please let me know how to make encryption and decryption with example?

1848


What is mapplet in informatica?

983


How do you load only null records into target?

1144


is it possible to index the data in cache of lkp transformation ?

1960


What is dimensional table?

1004


What do you understand by a term domain?

1063


Plz can any one say me how to get the informatica certification materials and dumps

2000


what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?

2256


What are the differences between source qualifier and joiner transformation?

996


What is the sql query overwrite in source qualifier in informatica

1029


How to load data in informatica ?

955