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
- 1 Answers
- 5075 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
What is joiner change?
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
What are the various types of transformation?
What are the transformations that are not supported in mapplet?
Mention few power centre client applications with their basic purpose?
How would you join a node to the already existing domain?
Explain what are the different versions of informatica?
How to do unit testing in informatica? How to load data in informatica ?
How to generate sequence numbers?
wat are deployement groups in informatica, how it will be used for developers
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
What is transformation?
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
Explain the types of lookup transformation?
