IBM Sterling Transformation Extender

Sterling Transformation Extender

Come for answers, stay for best practices. All we're missing is you.


#Sterling
#Supplychain
 View Only
  • 1.  Output data not populating in Mercator 6.5 map

    Posted 11/04/14 05:26 AM

    Originally posted by: vijji_WTX


    Hi All,

    Bit strange for me to see this issue in Mercator 6.5.

    I have a map with 1 input and 2 output cards.

    In1: student data set                    out1: mapped In1

                                                             out2:  F_map1( out1)

    If i display Out2 data as package it will display but when i map any filed from this set, it is not displays. output is created is empty

     

    In1: student data set                    out1: mapped In1

                                                             out2:  F_map1( in1)

    Map generates output correctly. both In1 and out1 uses same typetree. Any Clues

     

     


    #IBM-Websphere-Transformation-Extender
    #IBMSterlingTransformationExtender
    #DataExchange


  • 2.  Re: Output data not populating in Mercator 6.5 map

    Posted 11/04/14 07:00 AM
      |   view attached

    Originally posted by: paul.brett


    An example is worth a thousand words.  Please modify the enclosed, to demonstrate your issue.

    Thank-you

    Paul

    Follow me on Twitter


    #IBMSterlingTransformationExtender
    #DataExchange
    #IBM-Websphere-Transformation-Extender

    Attachment(s)

    zip
    Archive.zip   5 KB 1 version


  • 3.  Re: Output data not populating in Mercator 6.5 map

    Posted 11/04/14 09:43 PM

    Originally posted by: vijji_WTX


    Thanks Paul. I understand that 1-1 mapping is required for all groups/fields in order to get proper results. Why it does not work when i map root group to root group althrough input and output structure is same. When i use package(out1) it displays the data at last f_map, but when i map one field , it won't. 


    #DataExchange
    #IBM-Websphere-Transformation-Extender
    #IBMSterlingTransformationExtender


  • 4.  Re: Output data not populating in Mercator 6.5 map

    Posted 11/05/14 12:03 PM

    Originally posted by: Laurent(Satisco)


    Hello,

     

    did you try activating data audit on Out1 ? I had this issue in the past and it was linked to generating invalid output data.


    #IBM-Websphere-Transformation-Extender
    #DataExchange
    #IBMSterlingTransformationExtender


  • 5.  Re: Output data not populating in Mercator 6.5 map

    Posted 11/06/14 02:23 AM

    Originally posted by: vijji_WTX


    Hi Laurent, I activated data audit and able to see the Valid data. I believe 1-1 mapping will solve the issue.

    Not sure how functional map behaves deferently when we pass group from input card and group from output card.


    #DataExchange
    #IBM-Websphere-Transformation-Extender
    #IBMSterlingTransformationExtender


  • 6.  Re: Output data not populating in Mercator 6.5 map

    Posted 11/06/14 06:54 AM

    Originally posted by: paul.brett


    "Why it does not work when I map root group to root group although input and output structure is same."

    ....because this is how it was designed to work.  Perhaps you could review the REFORMAT() function and see if this helps you.

    Thank-you

    Paul

    Follow me on Twitter


    #IBM-Websphere-Transformation-Extender
    #DataExchange
    #IBMSterlingTransformationExtender


  • 7.  Re: Output data not populating in Mercator 6.5 map

    Posted 11/07/14 03:11 AM

    Originally posted by: vijji_WTX


    Thanks Paul your reply. I agree with your point. :-)


    #IBMSterlingTransformationExtender
    #IBM-Websphere-Transformation-Extender
    #DataExchange