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 |
What are the types of metadata that stores in repository?
what is tha tracesing level? and difference betweentrace in normal and verbose and nonverbose?
why do we go for update strategy tr in SCD rather using the session properties?
What are the Differences between connected and unconnected lookup?
Input is like 1 1 1 2 2 3 and out put should be 1 2 3 How can u acheive using rank transformation ??
Slowly changing dimensions, types and where will you use them
Can anyone please distinguish what is Inner join and Outer join
what is the size of your data warehousing?
how many data models u have done in informatica project?
How can you access the remote source into your session?
how did u understand business requirement?
Which version configuration tool used in ur project?