Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

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

requird output
maths science social
30 20 80

Question Posted / dinesh

Answers were Sorted based on User's Feedback



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

Answer / srikanth

select (select marks from sub where subject='maths') maths,
(select marks from sub where subject='science') science,
(select marks from sub where subject='social') social from
sub group by 1;

Is This Answer Correct ?    15 Yes 0 No

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

Answer / 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

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

Answer / keshava

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

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Informatica Interview Questions

hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you

0 Answers   IBM,

Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?

0 Answers   HCL,

Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?

0 Answers  

what is surrogate id ?

3 Answers   IBM,

why do we go for update strategy tr in SCD rather using the session properties?

3 Answers   IBM,

What is fact table? Explain the different kinds of facts.

0 Answers  

what is the difference between repository & Intergration service

1 Answers  

Sequence generator, when you move from develoment to production how will you reset

0 Answers  

How can you join 3 tables? Why cant you use a single Joiner to join 3 tables.

1 Answers  

1,If there are 3 workflows are running and if 1st workflow fails then how could we start 2nd workflow or if 2nd workflow fails how could we start 3rd workflow?

4 Answers   CompuSoft, EDS, TCS,

what is the size of u r project? and what is the size of source file?

1 Answers   HP,

what type of documents you receiving from client later wt can you do? what type of documents have to prepare?

2 Answers   CGI,

For more Informatica Interview Questions Click Here
Categories