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.  problem with handling bad data.

    Posted 09/26/08 11:35 AM

    Originally posted by: muralee


    i have a type tree with the following structure

    CLM_File

    CLM_Record(s)

    A5 Record(0:1)

    B0 Record(0:1)

    B5 Record(0:1)

    C0 Record(0:1)
    I have added RESTART option to CLM_Record.

    It is removing records in the Claim in the output data,if any of the records(A5,B0,B5 and C0) having bad data.

    But my requirement is to remove the complete CLM_Record,if any of the (A5...C0) records contains bad data and place the bad claims to seperate folder.

    can you please help me out.

    Thanks
    Murali.
    #IBM-Websphere-Transformation-Extender
    #DataExchange
    #IBMSterlingTransformationExtender


  • 2.  Re: problem with handling bad data.

    Posted 09/26/08 04:50 PM

    Originally posted by: raj1


    Use the reject function to capture the bad records into a separate file in a separate output card.All the goodones will goto the regular output card.If you want this written to a folder use -OF1 option to write the file to the required folder.
    #IBM-Websphere-Transformation-Extender
    #IBMSterlingTransformationExtender
    #DataExchange


  • 3.  Re: problem with handling bad data.

    Posted 09/26/08 09:32 PM

    Originally posted by: muralee


    Yes,i have used REJECT function with RESTART option.

    i am able to remove bad data from input file to output.

    But my requirement is,i need to remove the entire record if any of the detail records having bad data.

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


  • 4.  Re: problem with handling bad data.

    Posted 09/26/08 09:35 PM

    Originally posted by: muralee


    for example:

    Input:

    record-1
    abccdef
    asdas
    asdasd
    record-2
    sdfsd(bad data)
    sdfsdf
    fghfgh

    Output:
    record-1
    abccdef
    asdas
    asdasd

    the record 2 should be eleminate.

    but i am getting like this

    record-1
    abccdef
    asdas
    asdasd
    record-2

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


  • 5.  Re: problem with handling bad data.

    Posted 09/29/08 12:14 PM

    Originally posted by: SystemAdmin


    You need to define a Group in your type tree that contains the records to removed when a member of that group is invalid. Set the Restart attribute at the Group level.
    #DataExchange
    #IBMSterlingTransformationExtender
    #IBM-Websphere-Transformation-Extender