Delphix Products

Expand all | Collapse all

Link Partial Physical Database To dSource

Jump to Best Answer
  • 1.  Link Partial Physical Database To dSource

    Posted 06-29-2017 12:40:00 PM
    Hi
    is it possible to link partial physical database (i.e. only selected 5 or 10 tables) to dSource in Delphix?
    If possible please explain.
    Thanks.


  • 2.  RE: Link Partial Physical Database To dSource

    Posted 06-29-2017 01:02:00 PM
    Hello Manish,
                       Delphix links the full physical database, as dSource.

    Is there any particular reason, you want to link partial database?

    If the concern is about storage, Delphix engine will dedupe and compress the dSource very efficiently, as compared to physical database size.

    Thanks


  • 3.  RE: Link Partial Physical Database To dSource
    Best Answer

    Posted 06-30-2017 06:45:00 AM
    Hello Jatinder

    In my Physical Databases nearly 1000 tables are there but i need only 3 or 5 tables to virtualize.
    If i Virtualize 1000 tables it will take more memory(as compared to 3 or 5 Tables).

    So there is any other way to do this.

    Thanks




  • 4.  RE: Link Partial Physical Database To dSource

    Posted 06-30-2017 08:07:00 AM
    Hi Manish,

    Delphix isn't a product for virtualizing tables, you have to understand that it's using standard database API's to link (source) a database (eg : rman in case of oracle). As of this rman takes a full copy of the source database so all tables/schemas and so.

    As Jatinder stated delphix has an inteliegent filesystem that takes care of (compressing and deduplicating) what it will host (generally the ratio is between 60%-90%), this should answer your storage constraint and keep in mind that delphix reuse blocks instead of deplecating theme.

    Regards,

    Mouhssine