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 soource is having 10 records how will u insert 20 records to target

6 Answers   HCL,

---

What is the "File Repository" and how can we use that in the Informatica ? Please give one example of the Process ? waiting for Reply... Thank you .

4 Answers  

---

What is the Rankindex in Ranktransformation?

7 Answers  

---

How to jion 2 tables, without using any condition?

11 Answers   Amazon,

---

select * from emp where sal>(select min(sal) from emp) how to implement the same in informatica ?

5 Answers   Puma,

---

How to identify this row for insert and this row for update in dynamic lookup cache

3 Answers   CSC,

---

my source having 10 records but how can i load 20 records in target, i am not bother about duplicates?

10 Answers   Cap Gemini, Wipro,

---

What is the difference between the system variables $$$SessStartTime and SESSSTARTTIME?

2 Answers  

---

what is mean by grouping of condition column in lookup transformation?

1 Answers  

---

what are the fact table & dimensional table in pharmaceutical and hospotal related products???

0 Answers   IBM,

---

How does a sorter cache works?

0 Answers  

---

lookup transformation with screenshots

0 Answers   TCS,

---