Question { 6833 }

what is mapping optimization? wat are the techniques for tat

Answer

*Use sorted input in Aggretator transformation to decrease
the use of aggregate caches.If you use a Filter
transformation in the mapping, place the transformation
before the Aggregator transformation to reduce unnecessary
aggregation.

* We can use the Source Qualifier transformation to filter
as an alternate way to filter rows.

* Perform joins in a database when possible rather using a
joiner transform

*Adding an index to the columns used in a lookup condition
if you have privileges to modify the database containing a
lookup tables.

these are some simple techniques

Question { HSBC, 20039 }

we r using aggregator with out using groupby?

Answer

If we use Aggregator without using group by option we will
get only one row from source. It is a default charater of
Informatica.

e.g If there are 20 rows in the source table and only
using SQ and followed by Aggregator then target table then
the target table will be populated by the last row coming
from teh source table.