Data Warehousing Community Forum
February 08, 2012, 10:48:24 am

Pages: [1]   Go Down
« previous next »
  Print  
Author Topic: What is Mapplet?  (Read 11234 times)
Whoever
Administrator
*****

Reputation: +34/-0
Offline Offline

Posts: 124



View Profile WWW
« on: July 05, 2007, 11:28:22 am »
Hi,

What is a Mapplet?
What is the difference between a Mapplet and Reusable Transformation?

Update:
In Mapplet, What are all the Repository objects that are not supported in Informatica PowerCenter?
« Last Edit: July 05, 2007, 11:54:10 am by mOrpheuS » Logged
If most people said what’s on their minds, they’d be speechless.
Sipra
Founder
*****

Reputation: +59/-0
Offline Offline

Posts: 323


Am the King...


View Profile WWW
« Reply #1 on: July 05, 2007, 04:05:33 pm »
A Mapplet is a reusable object that represents a set of transformations. It allows you to reuse transforamtion logic and can contain as many transformations as you need.

A Mapplet can contain transformations, Reusable transformations and shortcuts to transformations.

The difference between a Mapplet and a Reusable transformation is -
A Mapplet is a set of transformations where as a reusable transformation is single transformation.

Mapplet is created in a Mapplet designer where as a reusable transformation is created in Transformation developer or Mapping designer.

The unsupported repository objects in Mapplet are -

  • COBOL source definitions
  • Normalizer Transformations
  • Non-Reusable Sequence generator transformations
  • Pre-session or Post-session stored procedures
  • Target definitons
  • PowerMart 3.5 - style LookUp functions
  • XML Source definitons
  • IBM MQ Source definitions
  • Other Mapplets
Logged
Sipra
Founder

www.dwforum.net
Raj2007
DW Apprentice
**

Reputation: +3/-0
Offline Offline

Posts: 25


Lightning for DW Forum


View Profile
« Reply #2 on: July 07, 2007, 05:47:01 pm »

Hi Sipra,

Can you please explain the limitation of transformations (i.e.., minimum and maximum number of transformations to be used) in a Mapplet?

Thanks in Adv...!
Logged
Sipra
Founder
*****

Reputation: +59/-0
Offline Offline

Posts: 323


Am the King...


View Profile WWW
« Reply #3 on: July 19, 2007, 11:55:15 am »
In a Mapplet, the usage of transforamtions is limited to some of them.

They are as follows -
   Source Qualifier              0 to 1
   Aggregator              Unlimited
   Filter             Unlimited
   Rank             Unlimited
   Update strategy             Unlimited
   ERP Source Qualifier             0 to 1
   Advanced External Procedure             Unlimited
   Expression             Unlimited
   Sequence Generator             Unlimited
   LookUP             Unlimited
   Stored Procedure             Unlimited
   External procedure             Unlimited
   Input (Mapplet)             0 to 1
   Output (Mapplet)             Unlimited and Minimun - 1
   Source definition              Unlimited
   Reusable transformations              Unlimited
   Shortcuts             Unlimited
Logged
Sipra
Founder

www.dwforum.net
Whoever
Administrator
*****

Reputation: +34/-0
Offline Offline

Posts: 124



View Profile WWW
« Reply #4 on: July 19, 2007, 12:43:43 pm »
Can we make a Reusable transformation to non-reusable?

If it can be done, Is there will be any effect on the mappings which have designed by using this Reuasble transformation?
Logged
If most people said what’s on their minds, they’d be speechless.
unknown
DW Apprentice
**

Reputation: +8/-0
Offline Offline

Posts: 44



View Profile
« Reply #5 on: September 09, 2007, 03:51:00 pm »
Quote
Can we make a Reusable transformation to non-reusable?

Definitely we can change a Reusable Transformation to Non-reusable, but the mapping that contains this Reusable Transformation will become invalid.
Logged
Thanks
Unknown Smiley
Sipra
Founder
*****

Reputation: +59/-0
Offline Offline

Posts: 323


Am the King...


View Profile WWW
« Reply #6 on: November 06, 2007, 04:59:29 pm »
Difference between a Mapplet and a Reusable Trransformation -

A Mapplet is a reusable object by "default".
And a Reusable Transformation has to be made reusable while creating a transformation.
Logged
Sipra
Founder

www.dwforum.net
Arvind
DW Apprentice
**

Reputation: +10/-0
Offline Offline

Posts: 78


View Profile
« Reply #7 on: November 21, 2009, 11:00:29 pm »
Has anybody have exposure on SQL Mapplets ??

If so please reply back...!  Lips sealed
Logged
regards,
Arvind
mark.darbar
DW Fresher
*

Reputation: +0/-0
Offline Offline

Posts: 6


View Profile
« Reply #8 on: January 11, 2010, 02:53:17 pm »
Reusable transformation is a single transformation which is reusable

mapplet means set of transformation which are reusable
Logged
Red Ant
DW Fresher
*

Reputation: +0/-0
Offline Offline

Posts: 2


View Profile
« Reply #9 on: February 17, 2010, 02:58:47 pm »
@ Sipra

Apart from the points you have told , is there any other disadvantage of using Mapplet?
Logged
Sipra
Founder
*****

Reputation: +59/-0
Offline Offline

Posts: 323


Am the King...


View Profile WWW
« Reply #10 on: March 15, 2010, 10:25:44 pm »
The main disadvantage of a mapplet is -

Suppose mapplet mplt_XYZ is having a unique functioanlity of some logic and its getting reused in say 15 different mappings of lets say 5 business division.
A logic needs to be added for say 3 business divisions and this will take a change og logic in say 8 mappings.
           In this scenario, mplt_XYZ can't be editted as it violates the logic in other 7 mappings. So all the 8 mappings to be revalidated by preparing logic separately thru some other mapplet or directly including the transformation logic.

Hope this sounds a valid explanation too for you.. revert back if you have any queries.. Roll Eyes
Logged
Sipra
Founder

www.dwforum.net
Allegra
DW Apprentice
**

Reputation: +17/-0
Offline Offline

Posts: 75



View Profile
« Reply #11 on: April 23, 2010, 10:16:06 am »
Quote from: Arvind on November 21, 2009, 11:00:29 pm
Has anybody have exposure on SQL Mapplets ??

I've never heard this one.
In Informatica 8.6 version also, there's no repository object of this kind.. Lips sealed
Logged
@llegr@
what do you call an Ant with an AK47 ?
Pages: [1]   Go Up
  Print  
« previous next »
 
Jump to: