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 Posted / vijaya
by using Deocde or case expression get the above o/p
Is This Answer Correct ? | 6 Yes | 2 No |
Post New Answer View All Answers
can any one give some examples for pre sql and post sql(Except dropping and creating index).
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
How to load a Dimension ? and how to load a fact table?
What is workflow manager?
I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?
Define update strategy?
Explain the mapping variable usage example in informatica
Which is the t/r that builts only single cache memory?
list out all the transformations which use cache?
How we can use union transformation?
expain about the tune parameters?
Target increases every day even though no new record was inserted
Tell me about Propagate functions in informatica
Plz can any one say me how to get the informatica certification materials and dumps
What are Dimensional table?