Answer Posted / rajesh

Take the source into expression and map it to instances of
target.

What is enterprise data warehousing?

1053

---

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

1867

---

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,

7189

---

What are the mapping parameters and mapping variables?

1210

---

suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?

7258

---

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

5685

---

What is powercenter on grid?

1184

---

What is the difference between informatica 7.0 and 8.0?

1018

---

What is an expression transformation?

1024

---

What is source qualifier transformation in informatica?

1018

---

How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

1131

---

What is dimensional table? Explain the different dimensions.

1175

---

How to differentiate between the active and passive transformations?

1171

---

Is stop and abort are same in informatica?

1005

---

Briefly explain the aggregator transformation?

1015

---