InfoSphere Optim

 View Only
Expand all | Collapse all

Affinity Transformation not working as expected in Optim 11.7 Z/OS

  • 1.  Affinity Transformation not working as expected in Optim 11.7 Z/OS

    Posted Tue November 29, 2022 10:32 PM
    Hello Team -

    I am using Optim TRANS affinity function for the following scenario.

    I have 2 tables with same column name and data to be same between these 2 columns. The columns are not Primary, Foreign and Unique keys. These column data is against an employee number but with duplicate values.

    I tried to use below Transformation to get the same data based on the source data but some of the data generated is differrent between these tables.

    TRANS PRO=AFF,ALGO=FPE,MTD=REP,KEY="FPEKEY123",ITERATIONS=20,TWEAKS=YES, FLDDEF1=(NAME=MPEG_DF,DT=CHAR)

    I expect the results for this as

    If  A is from source column, I expect A' from this function always
    if B is from source column, I expect B' from this transformation.

    Please let me know if I need to change something.

    ------------------------------
    Sampath Gelli
    ------------------------------

    #InfoSphereOptim
    #Optim


  • 2.  RE: Affinity Transformation not working as expected in Optim 11.7 Z/OS

    Posted Wed November 30, 2022 09:45 AM
    Edited by System Fri January 20, 2023 04:44 PM
    Hi Sam,

    Some examples would help explain the problem.

    Are you saying that you have the same source value in different tables. For example;
       'SE331' is a data value in multiple tables.  You are using the algorithm you stated to mask it and you get different results? (Table A might return 'BE374' and table B might return 'JJ123'.  Different results for the seemingly same source value.)

    Given this understanding. Is it possible that the source value in one of the tables has a space or other non visible character in the data?

    You can use the browse feature on the source extract files to look at the hex values of the source to see if there are non-visible characters. The steps to do so from the Browse Table Data window;
     1. find the data value in question (row and column)
     2. right click on the data cell
     3. select display -> Hex

    This will show the hex values similar to the following:
    SE331 
    000000
    000000
    543332
    353310

    In this example you can see a space at the end of the data.  

    If both source values are not exactly identical then you will get different results after masking.

    I hope this helps.

    ------------------------------
    ----------------------------------------------
    Tammy Ziegler
    tziegler@abmartin.com
    ------------------------------