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.  Handling Invalid data

    Posted 04/19/07 09:38 AM

    Originally posted by: SystemAdmin


    We have a data validation tree.if the data is valid then a "status" segment in the data is updated with AA.
    if the data is invalid then a "status" segment in the data is updated to AE.

    kindly suggest to achieve this.
    Thanks,
    Jignesh
    #DataExchange
    #IBM-Websphere-Transformation-Extender
    #IBMSterlingTransformationExtender


  • 2.  Re: Handling Invalid data

    Posted 04/23/07 05:55 AM

    Originally posted by: deepthideeps


    Hi,
    My understanding is that you need to display "AA" in the status field of O/P if data is valid else "AE".Please correct me if I'm wrong.

    If this is the scenario,You can use the Restart attribute in the Type tree and use CONTAINSERROR function in the mapping rule to identify valid and invalid data in the input.

    Thanks,
    Deepthi
    #DataExchange
    #IBM-Websphere-Transformation-Extender
    #IBMSterlingTransformationExtender


  • 3.  Re: Handling Invalid data

    Posted 04/23/07 06:33 AM

    Originally posted by: SystemAdmin


    Hi,
    Yes you have correctly interpreted.
    I m a newbie to WTX...plz elaborate...I have read about the restart attribute in the docs....please elaborate about it ...if possible a example would be of great help.
    Thanks,
    Jignesh
    #DataExchange
    #IBMSterlingTransformationExtender
    #IBM-Websphere-Transformation-Extender


  • 4.  Re: Handling Invalid data

    Posted 04/23/07 08:14 AM

    Originally posted by: deepthideeps


    Please try this.

    If your input type tree contains a group "A",then set Restart attribute to group A.

    O/P item Status=IF(CONATAINSERROR(A),"AE","AA")

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


  • 5.  Re: Handling Invalid data

    Posted 04/23/07 08:38 AM

    Originally posted by: SystemAdmin


    Thanks alot for reply.....
    plz brief about the group..

    I have a scenario where if the input is invalid the whole request is invalid.so in this case what should we identify as group....
    Thanks,
    Jignesh
    #IBM-Websphere-Transformation-Extender
    #IBMSterlingTransformationExtender
    #DataExchange


  • 6.  Re: Handling Invalid data

    Posted 04/24/07 12:29 AM

    Originally posted by: deepthideeps


    Group is a complex object containing other objects (files, records or
    rows for example)
    If the input class is a group(the input contains other objects),give restart attribute to the input.In that case,if there is any UFO or invalid data in the input file,the whole file will be treated as invalid.

    Thanks,
    Deepthi
    #IBM-Websphere-Transformation-Extender
    #IBMSterlingTransformationExtender
    #DataExchange