Answer Posted / narendra

in source qulifier we override query like this

select eno,sum(sal as totsal)from emp group by eno

pmscmd startworkflow -sv -d -u -p -f while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?

1445

---

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

1036

---

4 yrs etl devloper roles and responsibilities?any body give solutions

2077

---

Explain joiner transformation in informatica

1077

---

Describe data concatenation?

1007

---

What are the popular informatica products?

959

---

Why do we need informatica?

928

---

What is the difference between source qualifier transformations source filter to filter transformation?

998

---

How to create or import flat file definition in to the warehouse designer?

1024

---

What are the tasks that source qualifier perform?

1033

---

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

1808

---

Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?

1197

---

What is a sorter transformation?

1042

---

tell me about your project functionality

2296

---

server hot-ws270 is connect to Repository B. What does it mean?

2442

---