Answer / jd

this can be done using FIRST_VALUE() AND LAST_VALUE()

check the below link for more information

http://netezzamigration.blogspot.com/2014/10/lastvalue-and-firstvalue-best-example.html

Answer / kivi

first value and last value...

for more info ref 

http://etltechsolutions.wordpress.com/2014/10/12/last_value-and-first_value-best-example/

What is the difference between procedure and stored procedur?

2 Answers   IBM,

---

what is confirmed fact?

2 Answers  

---

where actually the usage of push down optimization happens...

2 Answers  

---

lookup is passive y can't it be active? let us say i have some records in my source like 101,rohit,1000 101,rohit,1000 102,kumar,2000 like wise now as it is having multiple matches i return only first,last value it can't return bouth the values that means lookup is acting as select distinct right by default what means it is active?

5 Answers   IBM,

---

My source is EmpID, Salary- (101, 1000)(102, 2000)(103, 3000). In the Target I want the following EmpID, Salary, Composite_Salary- (101, 1000, 1000)(102, 2000, 3000)(103, 3000, 6000). Please guide on how to build the mapping.

5 Answers   Amdocs,

---

Can we change Dynamic to Static or Persistent cache? If so what happens?

0 Answers   TCS,

---

What are the different types of transformation available in informatica.

0 Answers  

---

I have in my source Records like 100,101,102 etc. I have router transformation which has groups like one group is empno=100, second group is empno>99. Now i want to know my source record 100 loads into which group?

5 Answers   Span Systems,

---

What are the different caches used in informatica?

3 Answers   UST,

---

What is CHECK-IN CHECK-OUT. Please explane me?

3 Answers   TCS,

---

tell me the rules and responsblites in our project(my project is development)

0 Answers  

---

how can u tune u r informatica mapppings

2 Answers   CTS,

---