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.

In dimension and fact table? which one holds big data?

2 Answers  

---

What are the types of lookup transformation?

0 Answers   Informatica,

---

can you avoid static cache in the lookup transformation? I mean can you

1 Answers  

---

we have 20 records in source system, when we run for the 1st time, it should load only 10 records into the target, when you run for the second time it should load another 10 record which are not loaded. How do we do that? Can we write a SQL query in source qualifier to do it. This q' is asked in one f the interviews. Please let me know if anyone knows. Thanks

3 Answers   TCS,

---

WAT IS THE MEANING OF UPGRADTION OF REPOSITORY?

1 Answers   Wipro,

---

source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.

0 Answers   Cap Gemini, Cognizant,

---

what is target load plan

2 Answers   Cap Gemini,

---

what is the size of your data warehousing?

0 Answers   IBM,

---

differences between service based and product based?

0 Answers   Satyam,

---

How do you remove duplicate records in informatica?

1 Answers  

---

Explain why we use partitioning the session in informatica?

0 Answers  

---

What is data caches/ index caches?

0 Answers  

---