Answer Posted / devendar pd

if we use group by key columns in aggrigator then automatically duplicates will be removed, no need to create o/p port again.

I think we can't remove duplicates only by using filter

What are the guidelines to be followed while using union transformation?

1149

---

How to load the data from people soft hrm to people soft erm using informatica?

1025

---

how to load dimension table and fact table. plz tell me the steps.

2096

---

What all join we can perform in LOOKUP transformation?

991

---

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

---

What is target designer and target load order?

1116

---

The question was on time stamp. what is the difference between HH and HH24 when to use when.

2064

---

I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.

1712

---

What is the difference between writing a joiner query in ANSI style and THETA style?

2386

---

WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com

1926

---

What is the command used to run a batch?

1076

---

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

1283

---

As union transformation gives UNION ALL output, how you will get the UNION output?

1112

---

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.

1288

---

What are the differences between oltp and olap?

978

---