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

0 Answers   IBM,

---

Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?

0 Answers   IBM,

---

In which circumstances that informatica server creates Reject files?

2 Answers  

---

What are connected or unconnected transformations?

0 Answers   Informatica,

---

What are the popular informatica products?

0 Answers  

---

What is an MDDB? What is the difference between MDDBs and RDBMSs?

3 Answers  

---

What is a configuration management?

1 Answers  

---

Can you use flat files in Mapplets.

0 Answers  

---

What is the advantage of informatica?

0 Answers  

---

I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)

0 Answers   Saama Tech,

---

My flat file source is C_Id 1-nov-2011 8-nov-2011 100 2000 1500 101 2500 2000 I want my Target as C_Id Week_Num Amt 100 45 2000 100 46 1500 101 45 2500 101 46 2000

3 Answers   Wipro,

---

Hi, As shown below i have repositories under that some folder are there . Between these repositories and folder some thing is there.I want to know what is that? repositories repo1 repo2 repo3 IS_## IS_## IS_## Folder1 Folder2 Folder3 - - - Here i want to what IS_## represents ? Advance Thanks

1 Answers   IBM,

---