Answer Posted / zaheer

No, it is not possible to move data from ACTIVE & PASSIVE to
PASSIVE. Either both transformation should be ACTIVE or
PASSIVE in pipeline.

How do you handle two sessions in Informatica

1129

---

What are the basic requirements to join two sources in a source qualifier transformation using default join?

1104

---

what is SDLC way of code development?

2020

---

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

1838

---

Describe the impact of several join conditions and join order in a joiner transformation?

1046

---

my source is junk data how will u remove that junk data by using unix please any one replay me

3684

---

Differentiate between router and filter transformation?

1000

---

What are the tasks that source qualifier perform?

1089

---

if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.

2179

---

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

1698

---

TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com

1855

---

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

2103

---

How to update a particular record in target with out running whole workflow?

1568

---

What are the different options available for update strategy?

990

---

What is a joiner transformation and why it is an active one?

1060

---