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
Answer / vijaya
by using Deocde or case expression get the above o/p
Is This Answer Correct ? | 6 Yes | 2 No |
Do you find any difficulty while working with flat files as source and target?
How can we update a record in the target table without using update strategy?
how to join the 2 different table with different columns in informatica?
What is the grain level in DWH? If i have year to day. what is the grain level of DWH from year to day.
Explain lookup transformation is active in informatica
what is target update override and when we use it?
Is it possible to revert a global repository to local one and why?
How to fasten loading of 100 million distinct records in informatica? (Initially they are loaded into target without using any transformation, taking 2 hours)
why sequence generator should not directly connected to joiner transformation ?
can we send mail when ever it get success or faulure to other mailid?(Not company mail id)
What is a difference between complete, stop and abort?
How to update or delete the rows in a target, which do not have key fields?