select decode(subject,'maths',mark) maths ,decode(subject,

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

requird output
maths science social
30 20 80

Question Posted / brij

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

Please Help Members By Posting Answers For Below Questions

While importing the relational source definition from the database, what are the metadata of source that will be imported?

1276

What is the benefit of partitioning a session?

1188

What are the types of lookup transformation?

1086

What is a stored procedure transformation?

1061

What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?

7465

Explain why we use partitioning the session in informatica?

1102

How to load the data from a flat file into the target where the source flat file name changes daily?

1070

What does refresh system mean, and what are its distinctive choice?

1192

What is meant by lookup transformation? Explain the types of lookup transformation?

956

Why filter transformation is an active one?

992

What is the difference between router and filter?

1280

Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?

1096

How to do unit testing in informatica? How to load data in informatica ?

1135

Difference between Data and Index Caches?

1145

How do you load only null records into target? Explain through mapping flow.

2034