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.

how many types of dimensions are available in informatica?

1180

---

How can we handle two sessions in informatica?

1092

---

What are the transformations that are not supported in mapplet?

1084

---

Explain about cumulative Sum or moving sum?

1092

---

what are factless facts? And in which scenario will you use such kinds of fact tables.

1856

---

In informatica workflow manager, how many repositories can be created?

1437

---

difference between repository database and repository service?

1224

---

COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1

2004

---

What are the settings that you use to configure the joiner transformation?

1103

---

Tell me any other tools for scheduling purpose other than workflow manager pmcmd?

1382

---

What is the use of an aggregator cache file?

1248

---

-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?

5879

---

How to configure mapping in informatica?

1223

---

How can we use batches?

1064

---

What are the differences between oltp and olap?

1018

---