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 are the different types of code pages available in informatica & how to implement it in your project?

1 Answers   TCS,

---

what is the use of Java Transformation in Informatica 8.x?

2 Answers   TCS,

---

Explain sessions and how many types of sessions are there?

1 Answers  

---

What is the difference between lookup override and souce qualifier override ?

2 Answers   Puma,

---

100 records in source and i have 3 targets, my requirement is first record insert into 1st target,2 record into 2nd target,3 record into 3rd target and again 4th record into 1st target like dat..how to implement dis?

3 Answers   Polaris,

---

My source is this year 01/jun/2014 04/may/2015 09/mar/2017 my desired output is day month ye 01 jun 2014 04 may 2015 09 mar 2017 how do i acheive this

2 Answers  

---

in a table it has 200 rows the query is select 150 from tablename.whats the output

2 Answers   Cap Gemini,

---

in flatfile target how can u create header and footer plese give me the comands how will u write in session properties

3 Answers   Patni,

---

On a day, I load 10 rows in my target and on next day if I get 10 more rows to be added to my target out of which 5 are updated rows how can I send them to target? How can I insert and update the record?

6 Answers  

---

Is LOAD MANAGER AND LOAD BALANCER same in informatica?

1 Answers   KPIT,

---

How to get EVEN & ODD numbers separately?

8 Answers  

---

what is diffrence b/w joner and union transfermation

6 Answers  

---