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..

what is meant by lookup caches?

2 Answers   Cap Gemini, Informatica,

---

Plz can anybody send Informatica and Cognos FAQ Plz To thid ID ppradeep_dwh@yahoo.co.in

1 Answers  

---

What are the types of maping wizards that r to be provided in Informatica?

2 Answers  

---

in which situations do u go for sequence generator ?

2 Answers   TCS,

---

where actually the usage of push down optimization happens...

2 Answers  

---

hi i want to install latest informatica software in my pc..can anybody help me where should i get the infomatica software..plz help me

3 Answers  

---

What is deployment group?

0 Answers  

---

I have table name called Team and I have name and DOJ in that table in oracle, when I retrive the table in Informatica DOJ shows with date and time , I want want to know is it possible to get only date(MMDDYYYY) in the date data type,

3 Answers   CSC,

---

The question was on time stamp. what is the difference between HH and HH24 when to use when.

0 Answers   Nationwide,

---

what is bridge tables in informatica

1 Answers   CTS,

---

What does refresh system mean, and what are its distinctive choice?

0 Answers  

---

how to obtain performance data for individual transformations.

2 Answers  

---