Which objects cannot be used in a mapplet transformation

Questions by sivaramkumar

Showing Answers 1 - 21 of 21 Answers

tirumalesh

  • Mar 7th, 2007
 

Non-Reusuable Sequence generator cannot be used in maplet.

  Was this answer useful?  Yes

Ramana

  • Mar 7th, 2007
 

  • You cannot include the following objects in a mapplet:
    • Normalizer transformations
    • Cobol sources
    • XML Source Qualifier transformations
    • XML sources
    • Target definitions
    • Pre- and post- session stored procedures
    • Other mapplets

    •   Was this answer useful?  Yes

    kanak3

    • Mar 20th, 2007
     

    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 t o b e Normal.
    ♦You cannot include PowerMart 3.5-style LOOKUP functions in a mapplet.
    ♦You cannot include the following objects in a mapplet:
    −Normalizer transformations
    −COBOL sources
    −XML Source Qualifier transformations
    −XML sources
    −Tar ge t d e f i ni t i ons
    −Other mapplets

      Was this answer useful?  Yes

    Ravikumar Guturi

    • Mar 22nd, 2007
     


        Joiner Transfermation
      Normalizer transformations

      Cobol sources
    XML Source Qualifier transformations
    XML sources

    • Target definitions
    • Pre- and post- session stored procedures
    • Other mapplets

      Was this answer useful?  Yes

    prafulla kumar nayak

    • Mar 18th, 2014
     

    Below objects we can use inside maplet

    1.Non reusable sequence generator transformation.
    2.pre or post stored procedure transformation.
    3.Normalized transformation
    4.xml source qualifier transformation
    5.xml source
    6.target

      Was this answer useful?  Yes

    venkat

    • Apr 11th, 2014
     

    We can not use folloeing transformations in a mapplet.

    Target: This will change the difference between mapping and mapplet.

    XML and COBOL sources.
    Normalizer: Im not sure if we can use it as a transformation in data flow to convert rows into columns. but we can not use it as a source.

    Reusable sequence generator: Again we use a mapplet in so many other mappings, so the numbers generated will be shared among mappings. thats why this is prohibited in Mapplet. You can use normal sequence generator.

    Other mapplets: Mapplets within a maplet is prohibited. I think this is to reduce the complexity.

    Pre and post session stored procedure

    Thanks.

      Was this answer useful?  Yes

    Give your answer:

    If you think the above answer is not correct, Please select a reason and add your answer below.

     

    Related Answered Questions

     

    Related Open Questions