Interested to Buy Any Domain ? << Click Here >> for more details...
write a sql query following source?
subject mark
maths 30
science 20
social 80
requird output
maths science social
30 20 80
- 3 Answers
- 6855 Views
- iGate, I also Faced
- E-Mail Answers
Answer Posted / brij
select
decode(subject,'maths',mark) maths
,decode(subject,'science',mark) science
,decode(subject,'social',mark) social
from <<table>>
| Is This Answer Correct ? | 5 Yes | 3 No |
Post New Answer View All Answers
What is union transformation in informatica?
What is workflow manager?
How can we use batches?
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
Informatica settings are available in which file?
How to partition the Session?
Can we create a node as a gateway node and the same node can be assigned to a grid?
What are the new features of informatica 9.x in developer level?
Where do we use mapping variables in informatica?
To import the flat file definition into the designer where should the flat file be placed?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
What are some examples of informatica etl programs?
What is workflow? What are the components of workflow manager?
What is a repository manager?
What is meant by active and passive transformation?
