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.

What is domain in terms of informatica?

0 Answers  

---

How to do Half of the table ex: if 1000 records are there means 500 in one table and 500 in second table like this if N number of tables means how to do Half of the table ??????????

2 Answers   TCS,

---

Whether Aggrigator transformation ignore the null values or consider the null values ? Advance Thanks, Manojkumar

3 Answers   IBM,

---

Is it possible to revert a global repository to local one and why?

0 Answers  

---

Stage is which type of load is it a full load or incremental load Please let me know in detail with best example

3 Answers   Infosys,

---

when we dont use aggregator in mapping ?

2 Answers   CSC,

---

S1 is having 1 lakh records and s2 is having 100 records, s2 should compare s1 if emp no is same data should be updated if not their it should insert the data.what are the transformation used?

5 Answers   TCS,

---

Different qualification between a related rotate toward the sky and isolates look upward?

0 Answers  

---

Explian the Process of deployment groups in informatica

0 Answers   Informatica,

---

What are the different threads in DTM process?

2 Answers  

---

How can i send first half of the records to one target and Remaining to other target?

10 Answers   TCS,

---

i have oracle table A and target B. i don't know how many records. i want get get last record in table A as first record in target table B. write a sql query?

7 Answers   IBM, TCS,

---