InfoSphere Optim

 View Only
Expand all | Collapse all

mask oracle primary key column with max value +1 in destination table in convert request.

  • 1.  mask oracle primary key column with max value +1 in destination table in convert request.

    Posted Mon August 28, 2023 11:49 PM
    Edited by R G Mon August 28, 2023 11:52 PM

    Hello everyone, 

    Is there any way we could mask/replace primary key column with max value +1 in destination table in convert request. Appreciate your help.

    my source and target are same in this case. 

    and DB is oracle

    ------------------------------
    rajesh guttikonda
    ------------------------------



  • 2.  RE: mask oracle primary key column with max value +1 in destination table in convert request.

    Posted Tue February 06, 2024 02:39 PM

    I was able to achieve this by creating SQL file outside of Optim and write the value into file and read that file in Optim LUA script. 



    ------------------------------
    R G
    ------------------------------

    Original Message