Delphix Subset

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • Answered
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
Photo of Swathy Sukumar

Swathy Sukumar

  • 886 Points 500 badge 2x thumb

Posted 1 year ago

  • 0
  • 1
Photo of Mouhssine SAIDI

Mouhssine SAIDI

  • 4,782 Points 4k badge 2x thumb
Hi Swathy,

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

Regards,

Mouhssine
Photo of Robert Patten

Robert Patten, Employee

  • 520 Points 500 badge 2x thumb
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.  
Photo of Mouhssine SAIDI

Mouhssine SAIDI

  • 4,782 Points 4k badge 2x thumb
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