Answer / tgin

SELECT BOOKID,DECODE(LANGUAGE,'ENGLISH') AS LANGUAGE1,
DECODE(LANGUAGE,'FRENCH') AS LANGUAGE2,
(LANGUAGE,'SPANISH') AS LANGUAGE3
FROM TABLE_NAME
GROUP BY BOOKID

If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?

4 Answers   ABC, Cap Gemini,

---

wtite sql query following table are city gender no chennai male 40 chennai female 35 bangalore male 10 bangalore female 25 mumbai female 15 i want the output? city male female chennai 40 35 bangalore 10 25 mumbai null 15

3 Answers   Bank Of America,

---

how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?

0 Answers  

---

In dept 10, 5 emp sal, i want to do sum of dept 10 emp sal. Is there any othere transformation than the aggrator? if yes how?

5 Answers   Patni,

---

Can a joiner be used in a mapplet.

1 Answers  

---

---

HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION

0 Answers  

---

What are set operators in Oracle

3 Answers   Deloitte, Wipro,

---

How do you remove duplicate records in informatica?

1 Answers  

---

Name the different lookup cache(s)?

0 Answers  

---

I have name like INDIA in a column. I want display 1st line A, 2nd line N, 3rd line D, 4th line I, 5th line A in oracle data base?

1 Answers   Cognizant, HCL,

---

What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?

0 Answers   IBM,

---

What is the difference between Bulk Load and Normal Load

3 Answers   TCS,

---