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
Database version is 11g and this database is for some third party retail application.
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