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 |
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
how do u move the code from development to production?
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?
connected and unconnected lookups?
What is the maplet?
What is a repository manager?
Can we update the data in flat file using update strategy?
How will you update the first four rows and insert next four rows in a mapping?
Why can't we use few transformations in mapplet ? like xml and target defintions, seq etc ?
In warehouses how many schemas are there?
can u give example for factless fact table
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