We can use pivot finction on 11g instead of multiple decodes.

write a sql query following source?
subject mark
maths 30
science 20
social 80

requird output
maths science social
30 20 80

Question Posted / keshava

Answer Posted / keshava

We can use pivot finction on 11g instead of multiple
decodes.

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is the commit type if you have a transaction control transformation in the mapping?

1035

What are the performance considerations when working with aggregator transformation?

1157

Differentiate between sessions and batches?

1023

What are the informatica performance improvement tips

1101

In warehouses how many schemas are there?

1078

Name the different lookup cache(s)?

1237

COM components can be used in Informatica

2397

Explain the scenario which compels informatica server to reject files?

1171

What the difference is between a database, a data warehouse and a data mart?

1159

In which transformation you cannot drag ports into it?

1322

Explain the pipeline partition with real time example?

1144

how many types of dimensions are available in informatica?

1105

Design a mapping to load a target table with the following values from the above source?

1351

What is joiner change?

1151

When do you use sql override in a lookup transformation?

1101