Delphix Subset

  • 0
  • 1
  • Question
  • Updated 2 years 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 2 years ago

  • 0
  • 1
Photo of Robert Patten

Robert Patten, Employee

  • 770 Points 500 badge 2x thumb
Official Response
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.