Answer Posted / srinivas

dataflow

FF-----> Sourcequalifier...>aggregatore T/F....>target

in aggregator transformation add three new ports
o_col1,0_col2,o_col2 and make output ports
and expression in out ports
o_col1-----MAX(col1),
o_col2-----Max(col2),
o_col3-----Max(col3);
and connect these output ports to target
you will get the resul

What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?

7318

---

What is a connected transformation?

1051

---

Explain sessions?

986

---

Differentiate between a database and data warehouse?

1093

---

In which transformation you cannot drag ports into it?

1247

---

explain about unit testing? in real time?

2140

---

What is meant by LDAP users?

1114

---

Can we create a Integration service without a Repository service and vice versa?

1175

---

How do you load only null records into target?

1145

---

What is domain in terms of informatica?

957

---

In informatica workflow manager, how many repositories can be created?

1272

---

What is a stored procedure transformation?

993

---

What does reusable transformation mean?

1073

---

What could be the possible resons of locks by user?

1036

---

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

---