Answer Posted / sudhansu

A mapping which involves with complex Business logic.

What is meant by lookup transformation? Explain the types of lookup transformation?

956

---

Explain the informatica workflow?

1078

---

What do you mean by channel change?

1055

---

What is DR strategy for Informatica project?

1195

---

How many transformations can be used in mapplets.

1943

---

What are the different versions of informatica?

1280

---

What all are steps in up gradation of Informatica server?

1047

---

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

---

I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?

1911

---

what is mean by complex business rule ?

2170

---

Make a note of the quantity vaults made in informatica?

997

---

How to convert multiple rows to single row (multiple columns) in informatica

1387

---

Explain the types of transformations?

1075

---

Explian the Process of deployment groups in informatica

1065

---

r u done any partitions in ur project?

1832

---