Answer Posted / ankur saini er.ankur861@gmail.

yes aggregator ignore null values but joined consider
them...

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 are the components of the workflow manager?

1078

---

My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?

1873

---

What are active transformations.

1592

---

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

1085

---

Why filter transformation is an active one?

929

---

What are batches?

1010

---

Why sorter is an active transformation?

1130

---

What do you mean by worklet?

1017

---

Please let me know how to make Data masking in informatica..

1663

---

Can anyone tell me the new features in Informatica 9 Version?

2031

---

What is flashback table ? Advance thanks

1871

---

1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?

2075

---

What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?

7313

---

Why union transformation is an active transformation?

993

---