write a sql query following source?
subject mark
maths 30
science 20
social 80
requird output
maths science social
30 20 80
Answers were Sorted based on User's Feedback
Answer / srikanth
select (select marks from sub where subject='maths') maths,
(select marks from sub where subject='science') science,
(select marks from sub where subject='social') social from
sub group by 1;
Is This Answer Correct ? | 15 Yes | 0 No |
Answer / 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 |
Answer / keshava
We can use pivot finction on 11g instead of multiple
decodes.
Is This Answer Correct ? | 0 Yes | 0 No |
explain different levels in pushdown optimization with example?
What is dimensional table? Explain the different dimensions.
what is work of PUSH DOWN option
Explain pushdown optimization and types in informatica
can we use self join in informaitca?
Where do we use mapping variables in informatica?
How to update or delete the rows in a target, which do not have key fields?
What is deployment group?
What are the data movement modes in informatcia?
Hi I have been asked several times the following questions. 1.How does one do incremnental loading 2.Scenario - You are trying to load reasonable amount of rows into the target table, and its taking a helluva lot of time.What could be the reasons? I hate to answer these tw0 , gives me nightmares to even think of it!!! 3.Tell me any complex situation you have faced( as an Informatica Developer) and how did you resolve it. 4.tell me any complex mapping that you have done. All the experienced people out there , please please, reply to these questions.
Any one tell me some 5 session failure in real time?And why problem occur how to solve the issues?
What are the types of metadata that stores in repository?