Delphix Products

Expand all | Collapse all

Delphix Subset

Jump to Best Answer
  • 1.  Delphix Subset

    Posted 06-23-2017 04:31:00 AM
    Hi,
    Is it possible to execute the Provision job created in DMSuite in the Delphix Engine? 

    I'm currently trying to apply subset conditions to my Ruleset and push to my virtual target environment (Oracle) which is connected to a VDB. When I apply column subset and execute the Provision job, I see errors stating the column names are missing. I'm not sure if my understanding on Subset and Provision is right.

    Kindly help me

    Regards
    Swathy
    #Masking
    #OracleEBS


  • 2.  RE: Delphix Subset

    Posted 06-23-2017 07:39:00 AM
    Hi Swathy,

    Can you post the subset job configuration screens and error message please.

    Regards,

    Mouhssine


  • 3.  RE: Delphix Subset
    Best Answer

    Posted 06-27-2017 01:50:00 PM
    Provision jobs require source and target table(s) to contain the same columns and column definitions.  It is possible to subset rows via a filter or custom SQL but not columns.  Source and target can be physical or virtual in either direction.  


  • 4.  RE: Delphix Subset

    Posted 06-27-2017 02:06:00 PM
    Hi Robert,

    You can use filter condition / custom SQL ... to filter out the rows for beeing masked or even delete them.

    Notice that you can achive the same with masking job pre-script/post-script action from the masking console just by uploading a sql file order


    Regards,

    Mouhssine