Answer / satya

*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

Answer / madhava

To increase the running performance on mapping level.
Techniques of mapping optimization has follow:
1). If its having Filter TX on your mapping place it on
close to the SourceQualifier TX.
2). If in case you are having two or more same DB sources,
use the SQL Override and join it(Instead of Joiner).
3). Use the cache on lookup, Joiner, Aggregator TX. ; etc..

how to calculate the optimum cache size in aggregator transformation?

1 Answers  

---

how many types of dimensions are available in informatica?

0 Answers  

---

I want skip first 5 rows to load in to target? what will be the logic at session level ??

1 Answers   IBM,

---

,if we have single SQ in flow and we have router in which it has two group and we want to join these two groups with joiner ?is it possible?

3 Answers   Emphasis,

---

if i have a file having record sal=10000,and when use router with two groups having condition sal>5000 in one group,sal>7000 in other group.and if two groups connected to two targets.in which target sal=10000 will go?

9 Answers   BirlaSoft, Genpact, L&T, Syntel,

---

---

what is semi-additive fact?where did u used?

2 Answers  

---

i have 1000 records in my dource table, the same i have in target ,but a new column added in target as "batchno", and this column adds no 10 for 1st 100 records and 20 for next 100 records and 30 next 100 records and vice versa. how to acheive this?

6 Answers   Thomson Reuters,

---

what is a junk dimension ?

14 Answers   Atos Origin, Cognizant, HS, NIIT, TCS,

---

what is informatica metadata?

0 Answers  

---

how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?

2 Answers   Zensar,

---

In seqence generator transformation maximum limit is reached,after reaching maximum limit how will u insert the data

2 Answers   HCL, Schneider,

---

Which kind of index is preferred in DWH?

2 Answers  

---