write a sql query following source?
subject mark
maths 30
science 20
social 80
requird output
maths science social
30 20 80
- 3 Answers
- 6061 Views
- iGate, I also Faced
- E-Mail Answers
Answer Posted / keshava
We can use pivot finction on 11g instead of multiple
decodes.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is meant by incremental aggregation?
What is mapping debugger?
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
What are the features of complex mapping?
Explain target update override in informatica
What is workflow? What are the components of the workflow manager?
Why filter transformation is an active one?
Is it possible to revert a global repository to local one and why?
How can repository reports be accessed without sql or other transformations?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
The question was on time stamp. what is the difference between HH and HH24 when to use when.
How will the document be delivered to me?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
What is status code in informatica?
What is a filter transformation and why it is an active one?
