Answer / swetha

Master and detail source

Type of join

Condition of the join

Answer / raja

join condition


type of join
master and detail source

increase or decrease the cache sizes

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,

---

When we are using Dynamic Cache,which options we will select in session level?

1 Answers   Cognizant, CTS,

---

HOW DO YOU PARFORM INCREMENTAL LAOD ?

7 Answers   SAIC,

---

What is a configuration management?

1 Answers  

---

any body can say about all versions of informatica ?how many versions ?

2 Answers  

---

---

Write the prerequisite tasks to achieve the session partition?

0 Answers  

---

can we override a native sql query within informatica? Where do we do it?

0 Answers  

---

i have source like X1 10 X2 20 X1 30 X2 40 i want target as X1 X2 10 20 30 40 in informatica

2 Answers   HP,

---

How to identify this row for insert and this row for update in dynamic lookup cache

3 Answers   CSC,

---

I have source like this 1:2;3. so i want to load the target as 123

4 Answers   HP,

---

Why we use lookup transformations?

1 Answers  

---

what is the difference between Informatica7.1 & informatica 8.1

4 Answers  

---