Answer Posted / sreenu

Unconnected lkp is used for the performance preps bcz hear
we can return only one port and also it is not participated
in mapping directly in ulkp we can use only static cache.

Static cache: static cache is used in unconnected lkp, once
the data is cached it won’t modified.
Dynamic cache: in connected lkp we can use dynamic lkp. By
the use of dynamic lkp we can capture the changed
data.becage dynamic cache is automatically update the
cached data

Can we override a native sql query within informatica?

987

---

can any one explain about dataflow in the informatica project for bank domain....thanks is advance

10630

---

What are session parameters ? How do you set them?

1773

---

Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance

1950

---

HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION

1846

---

What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?

1605

---

Which development components of informatica have the highest usage?

984

---

Different circumstance which drives informatica server to expel records?

915

---

scenario where i can use only concurrent execution of workflow.

3062

---

What are the different options available for update strategy?

938

---

How to load a Dimension ? and how to load a fact table?

1370

---

Why do we need informatica?

926

---

server hot-ws270 is connect to Repository B. What does it mean?

2440

---

How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

1064

---

what are the fact table & dimensional table in pharmaceutical and hospotal related products???

2074

---