http://www.mydwbi.com/posts/list/3.page JForum - http://www.jforum.net http://www.mydwbi.com/posts/preList/359/2012.page http://www.mydwbi.com/posts/preList/359/2012.page GMT transformations and allows you to reuse that transformation logic in multiple mappings.

For example, if you have several fact tables that require a series of dimension keys, you can
create a mapplet containing a series of Lookup transformations to find each dimension key.
You can then use the mapplet in each fact table mapping, rather than recreate the same
lookup logic in each mapping.
When you use a mapplet in a mapping, you use an instance of the mapplet. Like a reusable
transformation, any change made to the mapplet is inherited by all instances of the mapplet.
Mapplets help simplify mappings in the following ways:
[list]Include source definitions. You can use multiple source definitions and source qualifiers
to provide source data for a mapping.[/list]
[list]Accept data from sources in a mapping. If you want the mapplet to receive data from the
mapping, you can use an Input transformation to receive source data.[/list]
[list]Include multiple transformations. A mapplet can contain as many transformations as you
need.[/list]
[list]Pass data to multiple transformations. You can create a mapplet to feed data to multiple
transformations. Each Output transformation in a mapplet represents one output group in
a mapplet.[/list]
[list]Contain unused ports. You do not have to connect all mapplet input and output ports in
a mapping.[/list]]]> http://www.mydwbi.com/posts/preList/359/2038.page http://www.mydwbi.com/posts/preList/359/2038.page GMT
[list]You can use pmrep to back up, disable, or enable a repository, delete a relational connection from a repository, delete repository details, truncate log files, and run multiple pmrep commands sequentially. You can also use pmrep to create, modify, and delete a folder.[/list]

[list]You can use pmrep to perform change management tasks, such as maintaining deployment groups and labels, checking in, deploying, importing, exporting, and listing objects. You can also use pmrep to run queries. The deployment and object import commands require you to use a control file to define options and resolve conflicts.[/list]]]> http://www.mydwbi.com/posts/preList/359/2039.page http://www.mydwbi.com/posts/preList/359/2039.page GMT A worklet is an object representing a set of tasks created to reuse a set of workflow logic in multiple workflows. You can create a worklet in the Worklet Designer.To run a worklet, include the worklet in a workflow. The workflow that contains the worklet is called the parent workflow. When the Integration Service runs a worklet, it expands the worklet to run tasks and evaluate links within the worklet. It writes information about worklet execution in the workflow log.

[list]Suspending Worklets[/list]
When you choose Suspend on Error for the parent workflow, the Integration Service also suspends the worklet if a task in the worklet fails. When a task in the worklet fails, the Integration Service stops executing the failed task and other tasks in its path. If no other task is running in the worklet, the worklet status is “Suspended.” If one or more tasks are still running in the worklet, the worklet status is “Suspending.” The Integration Service suspends the parent workflow when the status of the worklet is “Suspended” or “Suspending.”]]> http://www.mydwbi.com/posts/preList/359/2040.page http://www.mydwbi.com/posts/preList/359/2040.page GMT http://www.mydwbi.com/posts/preList/359/2041.page http://www.mydwbi.com/posts/preList/359/2041.page GMT