Answer Posted / peer

with the help of warehouse keys

What is source qualifier transformation in informatica?

967

---

What does role playing dimension mean?

1020

---

What are the advantages of using informatica as an etl tool over teradata?

998

---

How do you convert single row from source into three rows into target?

1116

---

Why update strategy and union transformations are active?

1010

---

How to join three sources using joiner? Explain though mapping flow.

1115

---

How to extract sap data using informatica?

1016

---

How can a transformation be made reusable?

1106

---

write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa

2533

---

Could you explain what is enterprise data warehouse?

1090

---

What is meant by query override?

1031

---

Explain target update override in informatica

1067

---

What is the use of transformation?

971

---

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

1090

---

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

1827

---