Answer Posted / santhoshn

By using PMCMD we can run workflow

What are the new features of informatica 9.x in developer level?

951

---

One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?

2223

---

What are the different types of repositories created using informatica?

1078

---

scenario where i can use only concurrent execution of workflow.

3092

---

Briefly describe lookup transformation?

994

---

What is update strategy transform?

1043

---

Which means the first record should come as last record and last record should come as first record and load into the target file?

1036

---

Difference between Target-based loading and constraint-based loading?

962

---

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

1821

---

What is intricate mapping?

1120

---

Explain Dataware house architecture .how data flow from intial to end?

2554

---

What do you mean by blocking transformation?

988

---

What is flashback table ? Advance thanks

1888

---

What is a transaction control transformation?

1158

---

Explain what are the different versions of informatica?

1053

---