1 Reply Latest reply: Jul 7, 2011 3:57 AM by jplogut-Oracle RSS

    Data Mart

    KannanB
      Hello All,

      I am fairly new to this concept. I can understand what is a data mart. But if anybody can clarify the following doubts it will be a great help.


      1. How data mart is implemented in Oracle?
      2. What are the applications used for this?
      3. Now we are following traditional SQL Loader to load data and UTL_FILE to extract data. How these concepts are going to be changed in Data Mart?
      4. I googled and found the following topics Oracle Data Mart Suite(which seems to be old), Oracle Data Integrator and Oracle Golden Gate. Which one is
      latest?

      Database version is 11g and this database is for some third party retail application.


      Kindly share your knowledge.

      Thanks & Regards,
      KB
        • 1. Re: Data Mart
          jplogut-Oracle
          Hello,
          This forum is for Migrations, so I am not sure that you easily find your answer here.
          May I suggest you first refer to the Oracle Data Mart documentation page ?
          It is located at http://www.oracle.com/technetwork/documentation/datamart-098795.html

          Kind regards,
          Jean-Patrick