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.  How to separate bad data from input file?

    Posted 08/14/08 06:14 PM

    Originally posted by: muralee


    I have a scenario:
    1) My input file contains 5 rows and each row will have 5 text items (fields).Out of 5 fields, only 2 fields are mandatory.
    2) In my input data, if any row didn’t contain those 2 mandatory fields, the map will fails saying “input type contains errors”.

    I need to separate the rows which didn’t have mandatory files or values in to a separate file.

    I should have 2 separate output files, one for good data and second for bad data.
    Can any one help me out with the sample solution?

    Please find sample map.

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


  • 2.  Re: How to separate bad data from input file?

    Posted 08/15/08 11:21 AM

    Originally posted by: Mr.WebSphreTX


    You can achieve this with restart atribute in type designer and Reject functionin map designer. Please read about restart atribute and how to use Reject function.
    #IBMSterlingTransformationExtender
    #DataExchange
    #IBM-Websphere-Transformation-Extender


  • 3.  Re: How to separate bad data from input file?

    Posted 08/15/08 12:03 PM

    Originally posted by: SystemAdmin


    See Chapter 18 of the Design Studio Tutorial.
    #IBM-Websphere-Transformation-Extender
    #DataExchange
    #IBMSterlingTransformationExtender