Answer / tgin

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

Where do you create/define mapping parameter and mapping variable?

1 Answers  

---

Define Update Override?

1 Answers  

---

What does update strategy mean, and what are the different option of it?

0 Answers  

---

What are your source in project and how you import in informatica? How can i explain abt this?

1 Answers   Accenture, Unisoft Infotech,

---

why union is active transformation?

4 Answers   IBM,

---

What is union transformation in informatica?

0 Answers  

---

What is a connected transformation?

0 Answers   Informatica,

---

Source Qualifier is an active t/r but there is no change of row count then y should we called it active t/r & Router , sorter some times no change in row count then Y we called its active t/r?

2 Answers  

---

What is deployemnt groups, Lables, query and dynamic deployment group.

1 Answers   IBM, SVP,

---

Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?

0 Answers  

---

what is the process of target load planing?

2 Answers   IBM,

---

waht type of interface is used for testing the data in informatica

0 Answers   CTS, TCS,

---