Answer Posted / v

using increamental aggregration

How to load the name of the current processing flat file along with the data into the target using informatica mapping?

1172

---

I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.

1220

---

What is the difference between source qualifier transformations source filter to filter transformation?

996

---

How to generate sequence numbers?

1029

---

how to create user defined function (udf) in informatica

1243

---

Mention few power centre client applications with their basic purpose?

891

---

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

1805

---

What is a predefined event?

1032

---

what is the Default Source Option For Update Strategy Transformation?

1166

---

Name at least 5 different types of transformations used in mapping design and state the use of each.?

1085

---

What is aggregate cache in aggregator transformation?

1061

---

How to generate sequence numbers using expression transformation?

1026

---

What is an aggregator transformation?

1030

---

Explain pushdown optimization and types in informatica

1015

---

difference between informatica 8.1.1 and 8.6

3626

---