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 diffrence b/w joner and union transfermation

6 Answers  

---

If I have set the property Treat Source Rows as Insert and for the target properties I have checked the boxes Update as Update, what will happen to incoming rows? What exactly is the use of these check boxes and in which scenarios we use them. Also what is the sequence in which informatica understands these properties.Does it takes whatever is defined in treat source rows as property or it is in any other way. Please explain.

3 Answers   Amdocs,

---

source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.

0 Answers   Cap Gemini, Cognizant,

---

How can you join two tables without any common column present in them?

1 Answers   TCS,

---

My Source qualifier has empno, sal. Now my mapping is like SQ(EMPNO)->AGGR->EXP->TARGET SAL ------------>TARGET ? Is this mapping valid or any issues are there if we design like this?

3 Answers   Span Systems,

---

How will you combine 3 different sources with a single source?

3 Answers  

---

tell me about your project functionality

0 Answers  

---

what is the architecture of any Data warehousing project?

5 Answers   IBM,

---

i have different sources in different databases ,that sources may be 100 tables i want to load these tables in to single target how to pearform the task

14 Answers   Altisource, TCS,

---

have u done any performance tuning? how u ll do?

0 Answers   IMB, TCS,

---

What is the use of an aggregator cache file?

0 Answers  

---

what are the challenge face in u r project?explain me

1 Answers   iGate, TCS,

---