What is difference between Mapplet and reusable
transformation?
- 9 Answers
- 41589 Views
- Wipro, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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
| Is This Answer Correct ? | 113 Yes | 4 No |
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.
| Is This Answer Correct ? | 16 Yes | 11 No |
Answer / maruthi
MAPPLET-REUSABLE COLLETION OF TRANSFORMATION CREATED TO
SOLVE A LOGIC.
REUSABLE TRANS-REUSABLE TRANSFORMATION.
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / manoranjan
Mapplet is a set of reusable transformations
but reusable transformation is a single Transformation
| Is This Answer Correct ? | 6 Yes | 3 No |
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.
| Is This Answer Correct ? | 6 Yes | 4 No |
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
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / biswa
Is mapplet a set of Re-usable transformations or it's a
reusable set of transformations?
| Is This Answer Correct ? | 0 Yes | 1 No |
Answer / vikneswaran
both were similar but mapplet consist set of reusable
transformation
| Is This Answer Correct ? | 0 Yes | 4 No |
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.
| Is This Answer Correct ? | 7 Yes | 113 No |
How can we use mapping variables in informatica?
What are the technical challenges faced in Informatica production support member? Give any one example and how to solve it?
what is lookup chache?
rank() over (partition by opt2.dim_plat_site_id, opt2.dim_site_opt_sid order by case when opt2.dm_market_flg in ('Y', 'U') then 1 else 2 end, lkp.contact_rank) as rank1, case opt2.contact_type when 'Buyer' then row_number() over (partition by opt2.dim_plat_site_id, opt2.dim_site_opt_sid, lkp.contact_rank order by has_name_flg desc, ship_to_flg desc , last_order_dt desc) when 'Decision Maker' then row_number() over (partition by opt2.dim_plat_site_id, opt2.dim_site_opt_sid, lkp.contact_rank order by has_name_flg desc , last_quote_dt desc , mailability_score desc , source_ranking desc) when 'Influencer' then row_number() over (partition by opt2.dim_plat_site_id, opt2.dim_site_opt_sid, lkp.contact_rank order by has_name_flg desc, mailability_score desc, source_ranking desc) when 'Payer' then row_number() over (partition by opt2.dim_plat_site_id, opt2.dim_site_opt_sid, lkp.contact_rank order by has_name_flg desc, mailability_score desc, source_ranking desc) --elu 05/28/2013 else row_number() over (partition by opt2.dim_plat_site_id, opt2.dim_site_opt_sid, lkp.contact_rank order by has_name_flg desc, mailability_score desc, source_ranking desc) end rank2 row_number() over (partition by opt3.dim_plat_site_id, opt3.dim_site_opt_sid order by rank1,rank2) as "rank", case when "rank"<= opt3.maximum_value then 'Y' else 'N' end as include_flg
What are parallel querys and query hints?
To provide support for Mainframes source data,which files r used as a COBOL files
how to import multiple flat files in to single target where there is no common column in the flat files
Why we use lookup transformations?
what type of documents you receiving from client later wt can you do? what type of documents have to prepare?
Source having one lakh record and loaded into target. Then, how can i compare records will loaded in table? For example Source having Firstname,Lastname. the same Firstname,Lastname record will be loaded into Target? How can i check in Oracle?
Explain the tuning lookup transformation - informatica
Explain lookup transformation in informatica
Teradata 
