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.

Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?

0 Answers  

---

what is parameter file?

1 Answers   Cap Gemini,

---

How can i generate Seqence Numbers to Tagret Table (with out using Seqence Gen Trans,Rank Trans).

5 Answers  

---

i have two flat files.. containing same type of data i want to load it to dwh..how many source qualifires i need

7 Answers   Deloitte,

---

What are the phases in SDLC?

3 Answers  

---

how can you load data into target table without leading zeor's

4 Answers   Deloitte,

---

What did you do in source pre load stored procedure

1 Answers  

---

How can you change from reusable session into non-reusable session.

5 Answers   Cap Gemini,

---

explain abt joiner t/r?

1 Answers   IBM,

---

I have data like sno mailid 1 subbu@dell.com 2 arthi@dell.com 3 thiru@dell.com .. ..... like this for N no.of how we will send a message 'meet hr' at a time in windows environment by the informatica..

2 Answers   DELL,

---

Input is like 1 1 1 2 2 3 and out put should be 1 2 3 How can u acheive using rank transformation ??

3 Answers   IBM,

---

How you prepared reports for OLAP?

0 Answers  

---