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 exactly mentioned in High level design document.can somebody explain me sequentialy.

1 Answers   IBM,


how to import multiple flat files in to single target where there is no common column in the flat files

2 Answers   TCS,


where to store informatica rejected data?

0 Answers  


what is mean by flag 4 in update strategy t/r

6 Answers  


How we will implement Pushdown Optimization and Types in Informatica with better examples

4 Answers   TCS,






Can informatica load heterogeneous targets from heterogeneous sources?

0 Answers  


I have a scenario with router transformation. but i dont want to capture records from default group. how can we achieve this.

3 Answers   Amdocs,


what is workflow varible

1 Answers   HP,


Implementation methodology

0 Answers  


What is Session and Batches?

0 Answers   Informatica,


what is unit testing?tell me proceedure

0 Answers   L&T, UST,


i have flat file it contains 'n' number of records, i need to send half of the records to one target table and Remaining half to another target table. can any tell me procedure.

2 Answers   TCS,


Categories