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

Do you find any difficulty while working with flat files as source and target?

0 Answers  


How can we update a record in the target table without using update strategy?

0 Answers  


how to join the 2 different table with different columns in informatica?

5 Answers   Accenture,


What is the grain level in DWH? If i have year to day. what is the grain level of DWH from year to day.

1 Answers   Zensar,


Explain lookup transformation is active in informatica

0 Answers   Informatica,






what is target update override and when we use it?

2 Answers   TCS,


Is it possible to revert a global repository to local one and why?

0 Answers  


How to fasten loading of 100 million distinct records in informatica? (Initially they are loaded into target without using any transformation, taking 2 hours)

3 Answers   Atriax,


why sequence generator should not directly connected to joiner transformation ?

1 Answers   ANZ,


can we send mail when ever it get success or faulure to other mailid?(Not company mail id)

1 Answers   Puma,


What is a difference between complete, stop and abort?

0 Answers  


How to update or delete the rows in a target, which do not have key fields?

0 Answers   Informatica,


Categories