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 InformaticaPowerCenter?

1071

What is DR strategy for Informatica project?

1114

How do you manage the Parameter files while migrating your data from one environment to another environment?

961

Please let me know how to make encryption and decryption with example?

1846

Why filter transformation is an active one?

928

How to elaborate powercenter integration service?

1071

What are the differences between a connected lookup and unconnected lookup?

1014

What are the types of caches in lookup? Explain them.

916

What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?

8124

What do you understand by a term domain?

1061

What is a code page?

1113

Explain the difference between mapping parameter and mapping variable?

978

What is blocking transformation?

1080

Explain what transformation and how many are there in informatica?

887

Whats the difference between informatica powercenter server, repositoryserver and repository?

1109