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...


write a query following table

bookid language
1234 english
1234 french
1234 spanish
1235 english

i want the output are

bookid lang1 lang2 lang3
1234 english french spanish
1235 english null null



write a query following table bookid language 1234 english 1234 french 1234 span..

Answer / tgin

SELECT BOOKID,DECODE(LANGUAGE,'ENGLISH') AS LANGUAGE1,
DECODE(LANGUAGE,'FRENCH') AS LANGUAGE2,
(LANGUAGE,'SPANISH') AS LANGUAGE3
FROM TABLE_NAME
GROUP BY BOOKID

Is This Answer Correct ?    4 Yes 2 No

Post New Answer

More Informatica Interview Questions

How do you implement unconn. Stored proc. In a mapping?

1 Answers  


what is workflow varible

1 Answers   HP,


What is best approach to load 100 different source files (Different structure) to differet target tables ?

2 Answers   IBM, TCS,


hi all my source looking like below column1 column2 101,102,103 abc,def,ghi 1001,1002,1003 a,b,c i want my target is column1 column1 101 abc 102 def 103 ghi 1001 a 1002 b 1003 c any one can you help

1 Answers  


what is the gap analysis?

1 Answers  


What are some examples of informatica etl programs?

0 Answers  


What is the difference between a router and a filter transformation?

1 Answers   TCS,


Please explain in detail with example about 1.Confirmed Dimension. 2.Junk Dimension. 3.Degenerated Dimension. 4.Slowly changing Dimensions

3 Answers   Infotech,


what are surrogate keys?

5 Answers  


How to load last n records of file into target table - informatica

0 Answers   Informatica,


What is a look up function? What is default transformation for the look up function?

2 Answers   ASM, TCS,


What is informatica metadata and where is it stored?

0 Answers  


Categories