Answer / saral mariyaprakasam

The active transformation can change the rows pass
through by it. The passive transformation can not make the
changes the rows pass through by it.
The active transformations are aggregator, application
source qualifier, custom, filter,joiner, Normalizer, rank,
router,sorter,source qualifier, transaction control,union,
update strategy,XML parser,XML source qualifier
transformations.
The passive transformations are custom,expression,
external procedure,input,lookup,output,sequence generator,
stored procedure transformations.

Answer / swetha

An active transforamtion can change the number of rows that
pass through it.

A passive transformation does not change the number of rows
that pass through it.

How to generate a single mapping for both the historical and incremental load.

2 Answers   CSC, TATA,

---

wt is the difference between truncate and delete in which situation u use delete and truncate in real time..

4 Answers   TCS,

---

Why use shortcuts(Instead of making copies).

1 Answers  

---

Which means the first record should come as last record and last record should come as first record and load into the target file?

0 Answers   Informatica,

---

How to use Normalizer transformation?

2 Answers  

---

guys which is the best institute in banglore to learn informatica??

2 Answers  

---

how to load dimension table and fact table. plz tell me the steps.

0 Answers   Cognizant, IBM,

---

What is the capacity of power cube?

1 Answers  

---

permutations of mapplet

0 Answers   TCS,

---

How to do unit testing in informatica? How to load data in informatica ?

0 Answers  

---

Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps

0 Answers  

---

What is meant by lookup transformation?

0 Answers  

---