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 is the need of session partitioning... how it is useful in real time
I want skip first 5 rows to load in to target? what will be the logic at session level ??
can anyone explain me about retail domain project in informatica?
What is a command that used to run a batch?
How can we use mapping variables in informatica?
Which means the first record should come as last record and last record should come as first record and load into the target file?
Discuss the advantages & Disadvantages of star & snowflake schema?
Why union transformation is an active transformation?
Explain direct and indirect flat file loading (source file type) - informatica
I have table name in that I have Rajesh Reshika Priya I want the result Like only Starting with R Rajesh Reshika Can someone help me to get these results and How?
what are types of dimentions?
Whats the difference between informatica powercenter server, repositoryserver and repository?