Answer / rajasekhar.

we can create a parameter file as previous_run_time and
current_run_time in the mapping. based on this time stamps
we can capture the new records which need to be insert and
update in the target table.

Answer / amarnath

pass the records to the lokup transformation. u get a new
lookup port, pass this to router. in router 1st condition
newlookuprow =0 second newlookuprow =1. pass the "0" to
update strategy for update and pass the "1" to another
update strategy for insert.

How do you load first and last records into target table?

0 Answers  

---

what is mapping override?

2 Answers   Cap Gemini,

---

source table have single column single record having with single space. load that source record into trg . trgt having two columns and the SOURCE TABLE LIKE COL1 BHANU PRASAD TRGT TABLE COL1 COL2 IN THAT LOAD THE RECORD IN THE trgt table LIKE COL1 COL2 BHANU PRASAD HOW ? TELL ME PLZ

2 Answers   Wipro,

---

what is the complex transformation you used in informatica

0 Answers   TCS,

---

What are the types of error logs available in Informatica?

1 Answers  

---

I have table name in that I have Rajesh Reshika Priya I want the result Like only Starting with R Rajesh Reshika Can someone help me to get these results and How?

3 Answers  

---

What is the difference between writing a joiner query in ANSI style and THETA style?

0 Answers   TCS,

---

If one flat file contains n number records., we have to load in target from 51 to 100.. how to use expressions in Informatica..?

2 Answers  

---

please let me know which type of question arise in interview on project manager round on insurance project with answer pls reply asap.

1 Answers   Accenture,

---

What are steps to follow Informatica migration from 7x to 8x? Pls Explain...

1 Answers   CTS, TCS,

---

we have to use order by,where,having we to implement sql query

1 Answers   Satyam,

---

What is junk dimention?

3 Answers   Patni,

---