Answer Posted / abhsihek

Hi neetu,
as i know that dynamic lookup alway increase the perfomence
compratively static cache if i am wrong please let me know.

Enlist some properties of sessions.

1135

---

What is confirmed fact in dataware housing?

7102

---

what is the Default Source Option For Update Strategy Transformation?

1286

---

What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?

1018

---

Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.

2347

---

how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.

1730

---

What is transformation?

1158

---

What is mapplet in informatica?

1123

---

What are the different lookup cache(s)?

1166

---

What are the steps involved in the migration from older version to newer version of Informatica Server?

2151

---

what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?

2370

---

5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C

1954

---

What are the types of lookup transformation?

1118

---

What is an unconnected transformation?

1129

---

In development project what is the process to follow for an etl developer from day1

1758

---