Answer / tgin

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

what is flat file override?

1 Answers   Cap Gemini, HP,

---

What are slowly changing dimensions?

5 Answers   Informatica, Verinon Technology Solutions,

---

explain abt ur project architecture?

0 Answers   Anthem, DELL, IBM, TCS, Wipro,

---

what is the process we used in joiner transformation,there is no matching column in sources?

2 Answers  

---

How to transform normalized data to denormalized form in informatica? Is there any logic or any transformations to achieve this?

3 Answers  

---

what are presession,postsession success and postsession failure commands ?

1 Answers  

---

how can we update without using update transformation. wt is push down operation in informatica. which lookup gives more tuning performance. if so why.

6 Answers   CTS, Symphony,

---

Create a mapping which contains 2 target tables. When the session runs for the first time it shud load Target table 1 and when it runs for second time it shud load Target table 2.

7 Answers   TCS,

---

3,if our source containing 1 terabyte data so while loading data into target what are the thing we keep in mind?

7 Answers   TCS,

---

in static and dynamic which one is better

2 Answers  

---

What is meant by lookup transformation?

0 Answers  

---

in realtime which situations u can use unconnected lookup transformation

2 Answers   Patni,

---