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
- 4997 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
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
can we override a native sql query within informatica? Where do we do it? How do we do it?
Sequence generator, when you move from develoment to production how will you reset
What is the Rank index port in Rank transformation?
What do think which one is the better joiner or look up?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
Explain pmcmd command usage in informatica
What is sq transformation?
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
What does command task mean?
What is the reusable transformation?
Differentiate between sessions and batches?
What is the difference between Active and Passive transformation?
Why update strategy and union transformations are active? Explain with examples.
Can we create a node as a gateway node and the same node can be assigned to a grid?
