write a sql query following source?
subject mark
maths 30
science 20
social 80
requird output
maths science social
30 20 80
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 workflow manager?
EXL informatica Questions
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
Informatica Checkpoints
What are the limitations of joiner transformation?
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
Explain the etl program with few examples.
Describe an informatica powercenter?
What is different between the data warehouse and data mart?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
How to do the error handling of if ur source is flatfiles?
What is Cognos script editor?
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
What is primary and backup node?
Which is the t/r that builts only single cache memory?