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 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
Tell me about Propagate functions in informatica
scenario where i can use only concurrent execution of workflow.
What do you understand by term role-playing dimension?
What is target designer and target load order?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?
How to do unit testing in informatica? How to load data in informatica ?
What is a filter transformation?
What is Index Caches size?
wat are deployement groups in informatica, how it will be used for developers
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
what is SDLC way of code development?
Differentiate between sessions and batches?
In informatics server which files are created during the session rums?
How can you validate all mappings in the repository simultaneously?