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 constraint based load order

2 Answers   Cap Gemini,

---

How does a rank transform differ from aggregator transform functions max and min?

0 Answers  

---

2,if we have 3 pipeline containing 3 targets and each target is connected with diff sequence generator ,let us assume first target is populated with seq no1-9,so what would be the number generated by other two sequence generator?what is the diff in o/p if when we use reusable sequence generator?what would be the diff if we place expression in between target and sequence generator?

2 Answers   Emphasis,

---

What is the function of aggregator transformation?

0 Answers  

---

i have two flat files.. containing same type of data i want to load it to dwh..how many source qualifires i need

7 Answers   Deloitte,

---

---

Explain joiner transformation in informatica

0 Answers   Informatica,

---

If we have 1000 rows were loaded in to datawarehouse and next day the source have 1010 rows so, how can we loaded only updated rows into target.

6 Answers   Accenture,

---

What are the out put files that the informatica server creates during the session running?

2 Answers  

---

What is partioning?how many types of partinings are there

2 Answers   HCL,

---

Which transformation can be created only as reusable transformation but not as non-reusable transformation?

1 Answers   Informatica,

---

I have source table 100 records after run session successfully but loads the target table 50 records only what happened that 50 records and how can i load remaining 50 records

5 Answers   Patni,

---

how to obtain performance data for individual transformations.

2 Answers  

---