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,

---

Explain pushdown optimization and types in informatica

0 Answers   Informatica,

---

What is the difference between lookup override and souce qualifier override ?

2 Answers   Puma,

---

Explain what transformation and how many are there in informatica?

0 Answers  

---

How to use Normalizer transformation?

2 Answers  

---

---

what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not

0 Answers  

---

wht is cdc?how to use it in creation of mappings?

6 Answers   HSBC,

---

I want load the data into target with out 1st and last record.

5 Answers   Yash Technologies,

---

TWO FLAT FILES ARE THERE , EACH HAVING NO MATCHING COLUMNS . HOW CAN U JOIN THESE TWO USING JOINER TRANSFORMATION ?

6 Answers   HP, TCS,

---

where to store informatica rejected data?

0 Answers  

---

Any one can tell me how to explain puss-down optimization ? explain me with example plz?

1 Answers  

---

source is a flat file empname, empno, sal ram, 101, 1,000 sam, 102, 2,000 ques: my target needs the data to be loaded as sal -1000 and 2000 excluding commas target empname, empno, sal ram, 101, 1000 sam, 102, 2000 how to implement this?

5 Answers   Polaris,

---