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

How big was your fact table

1861

Explain lookup transformation source types in informatica

1151

Why do you use Mapping Parameter and mapping variable?

1808

How to go to the older version for a mapping?

1157

Please let me know how to make Data masking in informatica..

1772

How to generate or load values in to the target table based on a column value using informatica etl tool.

1114

how to load dimension table and fact table. plz tell me the steps.

2142

How you prepared reports for OLAP?

1658

What is rank transform?

1061

Which files are created during the session rums by informatics server?

1233

Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?

1097

Explain in detail about scd type 1 through mapping.

1628

How can you define user defied event?

1075

Explain your project of banking domian.

1694

Differentiate between source qualifier and filter transformation?

1631