Answer Posted / madhavi

In the lookup transformation->properties->presql condtion
write delete from table_name where column_name="NULL";.

How many dimensions are there in informatica?

1134

---

What are the different clients of powercenter?

1114

---

Does an informatica transformation support only aggregate expressions?

1086

---

What is lookup change?

1108

---

can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project

2577

---

wat are deployement groups in informatica, how it will be used for developers

1770

---

Can we create a Integration service without a Repository service and vice versa?

1255

---

What is sorter transformation?

1108

---

What are the popular informatica products?

1056

---

What is option by which we can run all the sessions in a batch simultaneously?

1189

---

WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com

1962

---

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. ?

2085

---

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

1907

---

Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?

1187

---

What are the tasks that source qualifier perform?

1145

---