Answer Posted / user

just take a variable port

then write the condition
decode(id,null,prev_id,id)

prev_id =id(it should be a variable port)

i m just giving an idea

Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?

2410

---

What is a joiner transformation?

1037

---

What is an expression transformation in informatica?

1092

---

Explain pushdown optimization $pushdownconfig parameter - informatica

1195

---

What do you mean by worklet?

1117

---

What is a pre-defined event and user-defined event?

1083

---

What are the components of the workflow manager?

1183

---

How we can create indexes after completing the load process?

1201

---

What are the differences between joiner transformation and source qualifier transformation?

1238

---

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

1910

---

How to convert multiple rows to single row (multiple columns) in informatica

1429

---

What is the advantage of informatica?

1125

---

Explain what transformation and how many are there in informatica?

1029

---

where to store informatica rejected data?

1139

---

What are the main features of Oracle 8i with context to datawarehouse?

2160

---