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.  Restriction List

    Posted 12/04/14 05:47 AM

    Originally posted by: WTX_S


    Hello

    Please help me to understand the Restriction List in a better way.

    I know that restriction List includes all valid item and excludes all invalid item. But i want to make sure in what scenario these really helping? Please post with an example .

     

    Thanks in Advance.

     


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


  • 2.  Re: Restriction List

    Posted 12/08/14 02:53 PM

    Originally posted by: Arun Ramamurthy


    Note sure if you have reviewed the WTX documentation. It provides some information on using restrictions along with an example:

    http://www-01.ibm.com/support/knowledgecenter/?lang=en#!/SSVSD8_8.4.1/com.ibm.websphere.dtx.td.doc/concepts/c_type_design_Overview.htm

    ===========================

    Restrictions of an item type are the valid or invalid values for that item. "Include" restrictions are all of the valid values for an item. "Exclude" restrictions specify all of the invalid values.For example, a unit of measure field in the data must be one of a set of values: CN, BX, PK, BR. These values should be defined as "include" restrictions of the item UnitOfMeasure.

    Defining restrictions for an item restricts the valid data for that item. Partial lists of the valid values are not possible. For example, it is not possible to define the values for a certain item to be {A, B, C, "some other possible values"}.

    ===================================

    Also if you look into the states map example (<WTX_Install>\examples\general\states ) provided with the WTX install, the input tree has a StateID field and it lists a few states as below:

    OH - ohio

    IL - Illinois

    IN - Indiana

    --

    --

    This is in the Include restriction list. This would mean the incoming data for this field should contain one of the values mentioned in the list of values and anything else that comes in for this item other than the values in the list would be considered invalid and would fail the input validation.

    Hope this helps.

     

     

     


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


  • 3.  Re: Restriction List

    Posted 12/09/14 12:27 AM

    Originally posted by: WTX_S


    Hi Arun

    Thanks for your explanation. So from here i can clear that if we have multiple options( OH,IL,IN) for an i/p item(StateId), then we prefer to go for Restriction List. As per validation part, when it reaches StateId Field, it looks for the possible values  and choose according to the i/p file from the multiple options.

    I believe Choice is also doing the same thing. How this differ from Choice?

    Thanks


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


  • 4.  Re: Restriction List

    Posted 12/09/14 11:49 AM

    Originally posted by: Arun Ramamurthy


    If you are talking about the Choice group , I think that's for Items and groups within a tree and not for a list of values for an Item as in a restriction list.

    The Choice group has Items and groups as its components and in this list only one component is available.

    So as indicated in the example from documentation:

    Record

          Order

         Invoice

         Sales

     

    In the above , if the Record group is defined as a choice, then at any given instance only one component is available under the Record.

    http://www-01.ibm.com/support/knowledgecenter/?lang=en#!/SSVSD8_8.4.1/com.ibm.websphere.dtx.td.doc/concepts/c_type_design_Choice_Group_Components.htm

    ------------------------------------------------------

    A Choice group can have both items and groups as components. A partitioned Sequence group can only have group subtypes.

    Components of a Choice group must be distinguishable from each other. The components of a Choice group cannot have a component range other than (1:1). Only one component of a Choice group built in the output data.

    A Choice group data type is only one of the group components. For example, the data type Record is a group type with a Group Subclass of Choice. The group type Record has three components: Order, Invoice, and Sales. The data validation of Record will be only one of the components: Order, Invoice, or Sales. For this reason, the components of a Choice group must have a component range of (1:1).

    ----------------------------------------------------------------

     

     


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