1. WHAT IS A MAPPLET?
2. WHAT IS THE DIFFERENCE BETWEEN REUSABLE TRANSFORMATION AND MAPPLET?
3. WHAT ARE THE TRANSFORMATIONS THAT ARE NOT SUPPORTED IN MAPPLET? 77
4. IS IT POSSIBLE TO CONVERT REUSABLE TRANSFORMATION TO A NON-REUSABLE ONE?
5. WHAT IS THE USE OF MAPPLET & WORKLET IN PROJECT?
6. IS IT POSSIBLE TO HAVE A MAPPLET WITHIN A MAPPLET AND WORKLET WITHIN A WORKLET?
177.Mapplets are said to be reusable objects which simplify mapping by:
•Including multiple transformations and source definitions.
•Not required to connect to all input and output ports.
•Accept data from sources and pass to multiple transformations
Well, overall when it is required to reuse the mapping logic then the logic should be placed in Mapplet.
178. What is a Mapplet?
Mapplets are reusable objects that represent collection of transformations.
A Mapplet is a reusable object that we create in the Mapplet Designer.
•It contains a set of transformations and lets us reuse that transformation logic in multiple mappings.
179. What is the difference between Reusable transformation and Mapplet?
Any Informatica Transformation created in the Transformation Developer or a non-reusable promoted to reusable transformation from the mapping designer which can be used in multiple mappings is known as Reusable Transformation. When we add a reusable transformation to a mapping, we actually add an instance of the transformation. Since the instance of a reusable transformation is a pointer to that transformation, when we change the transformation in the Transformation Developer, its instances reflect these changes.
A Mapplet is a reusable object created in the Mapplet Designer which contains a set of transformations and lets us reuse the transformation logic in multiple mappings. A Mapplet can contain as many transformations as we need. Like a reusable transformation when we use a mapplet in a mapping, we use an instance of the
mapplet and any change made to the mapplet in Mapplet Designer, is inherited by all instances of the mapplet.
•one or more transformations.
•set of transformations that are reusable.
Reusable transformation :
•only one transformation
•Single transformation which is reusable.
180. What are the transformations that are not supported in Mapplet?
- Cobol sources
- XML sources
- XML Source Qualifier
- Target definitions
- Pre- and Post- session Stored Procedures
- Other Mapplet
- Normalizer transformations
- Non reusable sequence generator transformations.
- Target definitions
- Power mart 3.5 style Look Up functions
- XML source definitions
181. Is it possible to convert reusable transformation to a non-reusable one?
Reusable transformations are created in the Transformation Developer.
Another way is to promote a non-reusable transformation in a Mapping/Mapplet to reusable one **Converting a non-reusable transformation into a reusable transformation is not reversible.
But we can use the reusable transformation as a non-reusable one in any mapping or mapplet by dragging the selected Reusable Transform from the Repository Navigator and press the Ctrl key just before dropping the object in the Mapplet/Mapping designer.
The same applies for creating a non-reusable session from a reusable one in the Worklet/Workflow designer.
182. What is the use of Mapplet & Worklet in project?
Mapplet and Worklets allow you to create reusable objects and thus make your informatica code reusable.
Just like a procedure or function in a procedural language, we can build a mapplet or worklet, to incorporate a business logic, which can be used again and again in different mapping and workflow.
Mapplet can be created in PowerCenter Designer and reused in mapings. Worklet can be created in Workflow Manager and reused in Workflows.
183. Is it possible to have a mapplet within a mapplet and worklet within a worklet?
Informatica does not support mapplet within a mapplet transformation but it supports worklet within a worklet.