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

In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.

0 Answers  


how do u move the code from development to production?

3 Answers  


I want to run a workflow which consist of 3 sessions. But wat my question is. 1st session should run on DB1if the first session is successful then 2 session should run on db2 and 3rd session should run on DB3 envronments. i want 3 different wf logs. it shoul not override on one log?

1 Answers  


connected and unconnected lookups?

4 Answers  


What is the maplet?

0 Answers   Informatica,






What is a repository manager?

0 Answers  


Can we update the data in flat file using update strategy?

3 Answers  


How will you update the first four rows and insert next four rows in a mapping?

5 Answers   CTS,


Why can't we use few transformations in mapplet ? like xml and target defintions, seq etc ?

2 Answers   IBM,


In warehouses how many schemas are there?

0 Answers  


can u give example for factless fact table

2 Answers   TCS,


SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N

0 Answers   Infotech,


Categories