Answer Posted / 24/12/2007

if you need the source data after look up transformation to
transfer any other transformation more than once you can use
dynamic cache otherwise use static cache

What is a predefined event?

1053

---

How many input parameters can exist in an unconnected lookup?

1513

---

what are 3 tech challenges/ common issues you face?

2293

---

Explain target update override in informatica

1061

---

What are the new features of Power Center 5.0?

1720

---

What is joiner change?

1092

---

How to configure mapping in informatica?

1134

---

What is source qualifier transformation in informatica?

956

---

What are the informatica performance improvement tips

1038

---

4 yrs etl devloper roles and responsibilities?any body give solutions

2098

---

Why do you use Mapping Parameter and mapping variable?

1703

---

Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks

1820

---

What is the difference between STOP and ABORT options in Workflow Monitor?

1202

---

What is the use of an aggregator cache file?

1155

---

hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you

9760

---