Answer Posted / nagaraju bhatraju

Uncached lookup: The informatica server doesnot build a
cache for temporary starage of data. Wenever it need to
refer to the look up table, it scans the source directly.

Dynamic Cache: The informaatica server builds a cache of
the source wen the workflow runs for the first time and it
updates the cache records dynamically after each row it
loads to the target. Means, if a target row gets updated,
the dynamic cache also gets updated automatically after
that particular row comitted in the target.

or
Dynamic cache - can be configured as connected lookup only.
It does not support lookup on flat file. Can have only
equality operator in lookup condition.

Static cache - can be configured as connected as well as
unconnected lookup. Supports lookup on flatfile. Can have
any relational operator in lookup condition.

permutations of mapplet

2490

---

How we can create indexes after completing the load process?

1145

---

How to improve the performance of a session using sorter transformation?

1133

---

Explain load alternative records / rows into multiple targets - informatica

1137

---

Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?

2011

---

Explain constraint based loading in informatica

1076

---

How can we delete duplicate rows from flat files?

1204

---

Separate from an archive server and a powerhouse?

943

---

how many types of dimensions are available in informatica?

1070

---

What do you mean by channel change?

1022

---

What is a predefined event?

1082

---

How can you increase the performance in joiner transformation?

1181

---

How many dimensions are there in informatica?

1067

---

To import the flat file definition into the designer where should the flat file be placed?

1043

---

can u give example for factless fact table

6598

---