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.

Explain the pipeline partition with real time example?

869

---

How do you convert single row from source into three rows into target?

860

---

what is the hint? how to use it to reduce the query processing in program?

7076

---

How to call shell scripts from informatica?

751

---

Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?

894

---

What are the conditions needed to improve the performance of informatica aggregator transformation?

808

---

How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?

886

---

What is standalone command task?

992

---

wat are deployement groups in informatica, how it will be used for developers

1446

---

Can we create a node as a gateway node and the same node can be assigned to a grid?

841

---

What are the types of caches in lookup?

772

---

Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?

1543

---

 Informatica Checkpoints

3066

---

What is the need of etl tools?

818

---

What are the tasks that can be performed using sq?

820

---