Answer Posted / isha

Select all source rows.
The Dynamic Lookup transformation builds the caches from the target table.
When the lookup evaluates a row from the source that does not exist in the lookup cache, it inserts the row into the cache and assigns the NewLookupRow output port the value of 1. When the lookup evaluates a row from the source that exists in the lookup cache, it does not insert the row into cache and assigns the NewLookupRow output port the value of 0.
The filter in this mapping checks if the row is a duplicate or not by evaluating the NewLookupRow output port from the Lookup. If the value of the port is 0, the row is filtered out, as it is a duplicate row. If the value of the port is not equal to 0, then the row is passed out to the target table.

What are the types of presistent cache in look up tr.

2016

---

What are the components of workflow manager?

1030

---

Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?

1017

---

what is degenerated dimension?

3886

---

How to generate sequence numbers without using the sequence generator transformation?

1131

---

What is an unconnected transformation?

1040

---

if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.

2152

---

Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance

1936

---

How do you load unique records into one target table and duplicate records into a different target table?

1172

---

How can we delete duplicate rows from flat files?

1173

---

What is informatica?

1086

---

What does reusable transformation mean?

1083

---

generate date / time dimension in informatica

1077

---

explain one complex mapping with logic? sales project?

6611

---

can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.

3830

---