InfoSphere Optim

 View Only

  • 1.  create structure of database along insert or load jobs in infospeher optim TDM

    Posted Tue July 25, 2023 12:22 PM

    Hello All,

    Is it possible to create structure of Database in empty oracle target while loading data from source to target. 

    consider my oracle source has 10 tables (with PK and FK) and 3 views.

    Target is empty only with database and schema created. 

    while extracted/masked data into empty target, can we use optim and create the tables structure while loading data?



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


  • 2.  RE: create structure of database along insert or load jobs in infospeher optim TDM

    IBM Champion
    Posted Tue July 25, 2023 12:26 PM
    Rajesh,

    The Optim Insert/Load functions both allow for the "call create" function which should then list the object types and definitions in the converted extract file.  It will then create objects and show the status of the create.  Once created, it will then populate the tables.

    This all assumes the Optim user ID has the appropriate authorizations to perform such a process.

    --

    Jimmy Wilson


    1999 S. Bascom Ste 700

    Campbell, CA 95008

    Phone +1(972) 567-5558

    jwilson@abmartin.com

     

    Unstructured Data Masking

    Data Privacy/Test data Management - fabrication, optimization, obfuscation




    Original Message


  • 3.  RE: create structure of database along insert or load jobs in infospeher optim TDM

    Posted Tue July 25, 2023 02:18 PM

    got it. thanks jimmy. 



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

    Original Message