1 Reply Latest reply on Jun 12, 2019 1:59 PM by Adrian_Popescu-Oracle

    need to know if my master and work repositories will be created in database server and there will be some advantages of doing so or it can be created in any database in any server/node..

    3988035

      Hello All,

       

      I need to perform performance testing for Data warehousing solution.

      Need some input on performance test environment setup.

       

      I have separate servers for database (12C) and ODI (12C), need to know if my master and work repositories will be created in database server and there will be some advantages of doing so or it can be created in any database in any server/node.

       

      If metadata and data to be processed are in same server then it offers any performance benefit and hence recommended?

      If yes then what benefit and why/how beneficial?

       

      Thanks,

      Rajneesh