1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

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

Question Posted / dinesh


write a query following table bookid language 1234 english 1234 french 1234 span..

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

Post New Answer

More Informatica Interview Questions

In router source is a boy age 20 I given 3 conditions in router a>20, a<=20, a=20 which one exit first?

3 Answers  

How the Informatica Server reads perameter file?

1 Answers  

What is joiner change?

0 Answers  

Explain pushdown optimization and types in informatica

0 Answers   Informatica,

what r the transformations that r not involved in mapplet?

8 Answers   Wipro,




Can we insert and update a target table without using update strategy transformation?How?

4 Answers   Syntel,

Why can't we use few transformations in mapplet ? like xml and target defintions, seq etc ?

2 Answers   IBM,

Change Data Capture in Informatica,using Incremental Aggregation.How can i identify the these data in Target table.

2 Answers  

By using Transformation i need top most 5 employee salary from each deptwise? Deptno 10,20,30? which transformation we need to use?

8 Answers  

HOW TO GET THE LATEST DATA IN SCD ?

4 Answers   TCS,

How do you remove duplicate records in informatica?

1 Answers  

How do you create single lookup transformation using multiple tables?

6 Answers   TCS,

For more Informatica Interview Questions Click Here
Categories