Answer Posted / neeraj

By default aggregator does group by on each of the input
port so if 50 distinct rows are coming all will pass
through it..

If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?

9969

---

How can you differentiate between powercenter and power map?

1017

---

Where can we find the throughput option in informatica?

995

---

Explain dynamic target flat file name generation in informatica

1007

---

What do you understand by SOA of Informatica?

924

---

How many input parameters can exist in an unconnected lookup?

1490

---

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

1804

---

what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?

2251

---

without table how to come first record only in oracle?

2204

---

is it possible to index the data in cache of lkp transformation ?

1958

---

can u any challenge your project?

1971

---

What is status code in informatica?

959

---

r u done any partitions in ur project?

1750

---

How many transformations can be used in mapplets.

1870

---

What are the steps involved in the migration from older version to newer version of Informatica Server?

2041

---