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
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 |
How do you implement unconn. Stored proc. In a mapping?
what is workflow varible
What is best approach to load 100 different source files (Different structure) to differet target tables ?
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
what is the gap analysis?
What are some examples of informatica etl programs?
What is the difference between a router and a filter transformation?
Please explain in detail with example about 1.Confirmed Dimension. 2.Junk Dimension. 3.Degenerated Dimension. 4.Slowly changing Dimensions
what are surrogate keys?
How to load last n records of file into target table - informatica
What is a look up function? What is default transformation for the look up function?
What is informatica metadata and where is it stored?