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,

---

wt is inline view? when and why we Use ?mail to rayallarv@gmail.com

2 Answers  

---

Differences between version 7.x and 8.x.

0 Answers   Accenture, Cognizant,

---

In which transformation you cannot drag ports into it?

0 Answers   Informatica,

---

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.

0 Answers  

---

Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance

0 Answers   TCS, Wipro,

---

I have Employee table, 10 cols are connected to next transformation, only 4 cols are selected in SQL override. What would be passed to next col.

5 Answers   BirlaSoft,

---

What do you mean by blocking transformation?

0 Answers  

---

What is tracing level and what are the types of tracing level?

2 Answers   TCS,

---

What are the measure objects?

0 Answers  

---

how to design mapping half of source table records into one target and remaining half into another target

8 Answers   ABC,

---

Scheduling properties,whats the default (sequential)

0 Answers  

---