if we have input eno 1,2,3,1,2,3 year 2001,2002,2003,2001,2002,2003 and sal 10000,20000,30000,20000,30000,40000 ex-output eno totsal 1 30000 2 50000 3 70000

7 Answers  

---

What is update override?

1 Answers   Accenture,

---

I am having source ENO ENAME LOC 1 A PUNE 2 B MUMBAI 3 C CHENNAI Target ENO ENAME LOC 1 A PUNE 2 B MUMBAI 3 C CHENNAI If a new record coming from source from same location it should directly go to specified location in target at begining EX:if Eno with 4 coming from same Pune, It should directly load into the Pune location col with '|' symbol. Help me its very urgent

5 Answers   Polaris, Zensar,

---

What is the difference between view and materialised view?

6 Answers  

---

What is a shortcut and copy in Informatica and how two are different with each other?

0 Answers  

---

---

What are the methods for creating reusable transforamtions?

2 Answers  

---

How the informatica server sorts the string values in Rank transformation?

1 Answers   Informatica,

---

What are session parameters ? How do you set them?

0 Answers  

---

What do think which one is the better joiner or look up?

0 Answers  

---

What do you understand by a term domain?

0 Answers  

---

How to load the data from a flat file into the target where the source flat file name changes daily?

0 Answers   Informatica,

---

What is a passive transformation?

0 Answers   Informatica,

---