1 Reply Latest reply on Sep 28, 2004 12:33 PM by 407234

    SYCRONIZE DATA

    414419
      HI

      I WANT TO SYCRONIZE DATA FROM TABLE(MASTER) TO TABLE(DIMENSION);
      i.e WHEN TABLE(MASTER) GETS UPDATE/INSERT DATA IN TABLE(DIMENSION) SHOULD ALSO GET UPDATE/INSERT OF DATA. WHAT ARE THE VARIOUS OPTION POSIBLE AND WHICH IS THE BEST?

      1. TRIGGER ON TABLE(MASTER);
      WHICH WILL TAKE LOT OF TIME, I SUPPOSE.
      2. MERGE
      I DO NOT KNOW THE HOW MUCH TIME IT TAKE.

      OR IS THERE ANY OTHER OPTION SO THAT THE PROCESS IN ENTERPRISE MANAGER, IS AUTOMIZED?

      HELP!!!

      BYE

        • 1. Re: SYCRONIZE DATA
          407234
          Is your question still open?
          If so, tell me some more about this case:
          - Is this second table equal to the first one or is it totally different with just some fields from the first one?
          - Is it important to have the data refreshed online or can you manage using a refreshtime of some minutes?

          Regards,
          Georges.