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

What is informatica etl tool?

0 Answers  


What are the various types of transformation?

0 Answers  


What are batches?

0 Answers  


can we use lookup t/r in flat files?what are the t/r's can be used in flat files when compared to relational DB?

2 Answers   IBM,


How are indexes created after completing the load process?

0 Answers  


Differentiate between source qualifier and filter transformation?

0 Answers  


Which transformation should u need while using the cobol sources as source defintions?

2 Answers  


What is the diff. b/w informatica versions 8.1.1 and 8.6.1?

4 Answers   IBM, Wipro,


What are the different types of Type2 dimension maping?

2 Answers   CTS,


Where do we use mapping variables in informatica?

0 Answers  


Where are the source flat files kept before running the session?

0 Answers   Informatica,


i have 50500 records in my source.if wf run for the first time it will load 1000 records into 1 tgt,if runs second time it will load to another tgt.targets are FF and it is need to be created dynamically.how many tgt will be created and how?

1 Answers   HCL,


Categories