Answer / harithareddy

Reusable transformation is a single transformation which we
can use multiple times.
mapplet is a set of reusable transformations.which we can
use multiple times
The only diff is transformation is a single transformation
and mapplet is a set of reusable transformations

Answer / suresh

1.mapplet is a set of reusable transformations,we can use
multiple times
reusable transformations is a single transformation, that
we can used multiple times
2. in mapplet the transformation logic is hide
3.if u create any mapping variables or parameters in
mapplet that can't be used in another mapping or mapplet
unlike if u create in reusable transformation u can use in
another mapplet or mapping

4. we cant include source definition in reusable
transformation.but we can include source to mapplet

5. we cant use cobol source qualifier,joiner,normalizer
transformations in mapplet.

Answer / maruthi

MAPPLET-REUSABLE COLLETION OF TRANSFORMATION CREATED TO
SOLVE A LOGIC.

REUSABLE TRANS-REUSABLE TRANSFORMATION.

Answer / manoranjan

Mapplet is a set of reusable transformations

but reusable transformation is a single Transformation

Answer / rkreddy

Suresh, We can use Joiner transformation with in the
mapplet. If you know correct answer then only you have to
give the answer otherwise you should not give your's
expected answers.

Answer / ravi

MAPPLET IS SET OF REUSABLE TRANSFORMATION,WE CAN USE THIS MAPPLET IN ANY MAPPING WITH IN THE FOLDER
WHERE AS REUSABLE TRANSFORMATION IS SINGLE TRANSFORMATION,WE CAN USE MANY TIMES
*) IF WE CREATE MAPPING VAR OR PARAMETERS IN MAPPLET WE CAN'T USE IN ANOTHER MAPPING (OR) MAPPLET.
WHERE AS *) IF WE CREATE MAPPING VAR OR PARAMETERS IN REUSABLE WE CAN USE IN ANOTHER MAPPING (OR) MAPPLET.
*) IF YOU USE A STORED PROCEDURE TRANSFORMATION, YOU MUST CONFIGURE THE STORED PROCEDURE TYPE TO BE NORMAL.
YOU CANNOT INCLUDE THE FOLLOWING OBJECTS IN A MAPPLET:
1) NORMALIZER T/R
2) COBOL SOURCE
3)XML SOURCE QUALIFIER T/R.
4)XML SOURCE
5) TARGET DEFINITION

Answer / biswa

Is mapplet a set of Re-usable transformations or it's a
reusable set of transformations?

Answer / vikneswaran

both were similar but mapplet consist set of reusable
transformation

Answer / ande

Mapplet is nothing but reusable transformation, we can use
mapplet no of times. In case of reusable transformation we
can't use again.

One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?

0 Answers   TCS,

how do u fnd the duplicate rows and how to delete the duplicate rows?

2 Answers   IBM,

What exactly mentioned in High level design document.can somebody explain me sequentialy.

1 Answers   IBM,

my source is junk data how will u remove that junk data by using unix please any one replay me

0 Answers   Cap Gemini,

How can we use mapping variables in informatica?

0 Answers  

i have flat file it contains 'n' number of records, i need to send half of the records to one target table and Remaining half to another target table: pls full details

8 Answers   L&T, TCS, UnitedHealth Group, Wipro,

What is facttable granularity?

2 Answers  

What are the different threads in DTM process?

1 Answers  

What are the types of error logs available in Informatica?

1 Answers  

my source is like this id,name sal 10 abc 1000,10 pqr 2000, 10 xyz 3000 ,10 jkl 4000 and my requirement is like this 10 abc,pqr,xyz,jkl 2000 .... i have try for this by using expression transformatin its ok of the concatenation of second column but the thing is that on third column if u group by using agg t/r the last value will com i.e 4000 but i asked by a interviewer that i dont want the first or last column i want the middle column i.e 2000 .plz reply for the same

2 Answers   KPIT,

Explian the Process of deployment groups in informatica

0 Answers   Informatica,

How do we call shell scripts from informatica?

0 Answers