Saturday 11 June 2011

Informatica Transformations



Mapping: Mapping is the Informatica Object which contains set of transformations including source and target. Its look like pipeline.
Mapplet:
Mapplet is a set of reusable transformations. We can use this mapplet in any mapping within the Folder.
A mapplet can be active or passive depending on the transformations in the mapplet. Active mapplets contain one or more active transformations. Passive mapplets contain only passive transformations.
When you add transformations to a mapplet, keep the following restrictions in mind:
  • If you use a Sequence Generator transformation, you must use a reusable Sequence Generator transformation.
  • 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:
    • Normalizer transformations
    • COBOL sources
    • XML Source Qualifier transformations
    • XML sources
    • Target definitions
    • Other mapplets
  • The mapplet contains Input transformations and/or source definitions with at least one port connected to a transformation in the mapplet.
  • The mapplet contains at least one Output transformation with at least one port connected to a transformation in the mapplet.
Input Transformation: Input transformations are used to create a logical interface to a mapplet in order to allow data to pass into the mapplet.
Output Transformation: Output transformations are used to create a logical interface from a mapplet in order to allow data to pass out of a mapplet.

No comments:

Post a Comment