Answer Posted / etl guru

Hey fools, understand the question. The question is "Data
is passed from one active trans and one passive trans
into a passive transformation.Is the mapping valid or
invalid?"
The answer is: Mapping is invalid. We can never connect a
data from Active and passive transformation TO A PASSIVE
TRANSFORMATION. Can you connect output of a joiner and
Expression to an expression transformation?

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

611

---

what are the fact table & dimensional table in pharmaceutical and hospotal related products???

1697

---

Whats the difference between informatica powercenter server, repositoryserver and repository?

675

---

What are the different types of olap? Give an example?

564

---

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

1411

---

---

What is the fact table?

590

---

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

1532

---

Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab

1651

---

Is stop and abort are same in informatica?

571

---

What is the different lookup cache(s)?

613

---

Explain load alternative records / rows into multiple targets - informatica

687

---

What is an Integration service in Informatica?

705

---

Which transformation is needed while using the Cobol sources as source definitions?

727

---

Under what condition selecting sorted input in aggregator may fail the session?

663

---

What is difference between a gateway node and worker node?

627

---