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...


write sql query following table
pname description
lux soap
sunsilk shampoo
lux shampoo
sunsilk soap
clouseup soap
closeup paste

i want the output like

pname description
lux soap
sunsilk shampoo
lux soap
sunsilk shampoo
closeup paste
closeup paste



write sql query following table pname description lux soap sunsilk shampoo lux shamp..

Answer / vijaya

by using Deocde or case expression get the above o/p

Is This Answer Correct ?    6 Yes 2 No

Post New Answer

More Informatica Interview Questions

Explain load alternative records / rows into multiple targets - informatica

0 Answers   Informatica,


What happens if we dont select data driven option?

2 Answers   Zensar,


two types of data are there . one is mainframe and the other is ascii format . in informatica how can you get both the data in a single format in ascii .

2 Answers   TCS,


What if the source is a flat-file? Then how can we remove the duplicates from flat file source?

1 Answers  


How we can get unique records into one target table and duplicate records into another target table??

11 Answers   Deloitte, IBM, iGate,


why we use stored procedure transformation?

4 Answers   IBM,


What is domain and gateway node?

0 Answers  


HOW TO YOU LOAD TIME DIMENSION

1 Answers  


i have a source table and 3 target table. when session runs first time-1st tgt second time-2nd tgt third time-3rd tgt fourth time-again 1st target. so no

4 Answers   HCL,


I have the input file as col1 col2 col3 3 2 1 7 6 8 I should get the output as col1 col2 col3 1 2 3 6 7 8 ....What is the logic to get this? Is there any transformation which sorts row wise ? If not how to sort the incoming records row wise?

5 Answers  


TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com

0 Answers   TCS,


how can we check whether a particular cache is static or dynamic?

1 Answers   InfoCepts, TCS,


Categories