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
- 7005 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 are the components of workflow manager?
can we override a native sql query within informatica? Where do we do it?
what is the -ve test case in your project.
What are the steps involved in the migration from older version to newer version of Informatica Server?
Why do we need informatica?
How do you migrate data from one environment to another?
What are the differences between joiner transformation and source qualifier transformation?
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
What is data caches/ index caches?
What does update strategy mean, and what are the different option of it?
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
What is union transformation?
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
Name the different lookup cache(s)?
