Answer / srinu

Selects all rows.
Caches the existing target as a lookup table.
Compares logical key columns in the source against
corresponding columns in the target lookup table.
Compares source columns against corresponding target
columns if key columns match.
Flags new rows and changed rows.
Creates two data flows: one for new rows, one for changed
rows.
Generates a primary key for new rows.
Inserts new rows to the target.
Updates changed rows in the target, overwriting existing
rows.

How many ways are there to create ports?

0 Answers   Informatica,

---

explain about lookup t/r?

1 Answers   IBM,

---

What is mapplet and a reusable transformation?

2 Answers  

---

Performance tuning( what you did in performance tuning)

0 Answers   Infosys,

---

What is lookup change?

0 Answers  

---

What is depict expression change?

0 Answers  

---

what is the difference between Informatica7.1 & informatica 8.1

4 Answers  

---

State the differences between sql override and lookup override?

0 Answers  

---

i have flat file it contains 'n' number of records, i need to send half of the records to one target table and Remaining half to another target table. can any tell me procedure.

2 Answers   TCS,

---

i have a wf like wf-->s1-->s2-->s3-->s4 first start s1 later s2 later s3 here my session s3 have to run 3 times later start s4?

3 Answers   IBM,

---

Please let me know how we can implement the below scenario. In a single mapping,more than 500 sources (legacy,VSAM,relational) will be loading into only one target. Whenever I retreive the data(any record) from target, i need to find the details that the record belongs to which source. Thanks in advance..

5 Answers   iGate,

---

Reusable transformation and shortcut differences

0 Answers  

---