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

Differentiate between joiner and lookup transformation?

1159


What is expression transformation?

1145


How to improve the performance of a session using sorter transformation?

1187


Explain the informatica workflow?

1127


What is the meaning of up gradation of repository?

2053


In warehouses how many schemas are there?

1129


can u any challenge your project?

2084


What are the new features of informatica 9.x developer?

1028


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

2105


How to do unit testing in informatica? How to load data in informatica ?

1185


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?

1020


How to create a non-reusable instance of reusable transformations?

1170


When do you use sql override in a lookup transformation?

1140


What does refresh system mean, and what are its distinctive choice?

1274


Write the unconnected lookup syntax and how to return more than one column.

1148