Answer Posted / parameswarareddy

UNION
UNION ALL
MINUS
INTERSECT

Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?

1135

---

Which version configuration tool used in ur project?

3267

---

How can we use mapping variables in informatica?

1070

---

How would you join a node to the already existing domain?

1135

---

What are the types of presistent cache in look up tr.

2059

---

How to go to the older version for a mapping?

1109

---

What are junk dimensions?

1076

---

how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?

7085

---

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

1868

---

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

1090

---

While migrating the data from one environment to another environment how would you manage the connections?

1096

---

What is powercenter on grid?

1190

---

What is standalone command task?

1320

---

What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks

5689

---

How can we remove the duplicates from flat file source?

1047

---