write a query following table bookid language 1234 english 1234 f

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

Question Posted / dinesh

1 Answers
5074 Views
TCS, I also Faced
E-Mail Answers

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

source table have 3 records? and it is sucessfully loaded into target. and 4more records is added in to source .that means 7 records now in source. we have to load the remaining 4 records into the same trgt table with maintian top 3 records. how ?can any one give me the data flow of this logic plz?

5 Answers Wipro,

What are the different types of repositories created using informatica?

0 Answers

I am having a FLAT FILE SOURCE as first line: 1000,null,null,null second line as:null,2000,null,null 3rd line as :null,null,3000,null and final line as: null,null,null,4000 ............................Now i want the OUTPUT as 1000,2000,3000,4000 to a FLAT FILE only.For more clarification i want to elimate nulls and want in a single line. Please help me out

5 Answers IBM,

Hey I am net to informatica? Can any one explain me step by step How scd will work ?

1 Answers Infosys,

What is the use of source qualifier?

0 Answers

What is data caches/ index caches?

0 Answers

What are the issues that you have faced while moving your project from the Test Environment to the Production Environment?

1 Answers

r u done any partitions in ur project?

0 Answers TCS,

Different sorts of metadata that stores in the storage facility?