Answer Posted / zer0

The purpose of ur question is to update male to female and
female to male .......... is it so, then

Source --> SQ --> Expression --> Target

Use an expression transformation and make 1 variable port
in it say gender_check, put the condition in it as

IIF(gender=male,female,male)

make a output port say gender_new and give the value of
gender_check as output.Use gender_new as output to target.

Kindly revert if this worked.

What is workflow? What are the components of the workflow manager?

1108

---

Can we create two repositories on same database instance in oracle?

1075

---

What are some examples of informatica etl programs?

919

---

scenario where i can use only concurrent execution of workflow.

3142

---

How many input parameters can exist in an unconnected lookup?

1532

---

What do you mean by filter transformation?

938

---

How to update source definition?

1077

---

What are the different versions of informatica?

1247

---

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

1840

---

What are the new features of informatica 9.x in developer level?

975

---

Separate from an archive server and a powerhouse?

944

---

What you know about transaction control transformation?

980

---

In development project what is the process to follow for an etl developer from day1

1701

---

How to use procedural logic inside infromatica?

1203

---

What do you mean by channel change?

1022

---