Answer Posted / hari

By default lookup is static.
Dynamic is used whn the records coming frm the source to
target in multiple times. i.e if
1)
emp_id=101...city=hyd...age=25...
(first this is inserted to target)
2)at second time when 101 employee is changing his city frm
hyd to chennai here we need to update the target table with
city name as chennai. thn how lookup cache knows tht a
record is updated...
3) if it is static lookup, after updating tht record it
will not refresh the lookup cache.... where as if it is
dynamic cache it will refresh the cache....
4) Based on our requirement we r going to use.....

How to extract the informatica rejected data?

1210

---

Reusable transformation and shortcut differences

1838

---

How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?

2026

---

How to create Target definition for flat files?

1210

---

What is meant by incremental aggregation?

1095

---

What is a filter transformation and why it is an active one?

966

---

What the difference is between a database, a data warehouse and a data mart?

1147

---

What is the way to execute pl/sql script using informatica mapping?

1589

---

list out all the transformations which use cache?

1175

---

What are the components of workflow manager?

1083

---

tell me about your project functionality

2339

---

What is intricate mapping?

1190

---

Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,

7177

---

Enlist the differences between database and data warehouse.

1112

---

Explain how to import oracle sequence into informatica?

1002

---