You can use Smart Analytics Optimizer Studio to
create the data mart definitions when you are familiar with the database
schema and the application queries that are sent to the database server.
Smart Analytics Optimizer Studio estimates
how large the data mart might become and determines if there is sufficient
space on the accelerator server for the proposed data mart.
To
create a data mart definition using Smart Analytics Optimizer Studio use
the following steps:
- On the computer where Smart Analytics Optimizer Studio is
installed, start Smart Analytics Optimizer Studio:
- On Linux, open the
directory where you installed Smart Analytics Optimizer Studio,
and then run the ./datastudio command.
- On Windows, select
- Create a new accelerator project. Right-click the Accelerators folder
and select New Accelerator or choose .
- Use the New Data Mart wizard to create a data mart definition.
Choose to start the New DataMart
Wizard. The New Data Mart wizard uses the existing database
connection to read the catalog tables in the database and to retrieve
information about the objects in the database, such as the tables,
constraints, and so on. The wizard uses this information to create
resources in the workspace on your computer.
- Add database tables to the data mart definition.
- A single data mart definition can have a maximum of 255 tables
or 750 columns
- If you add a table to your data mart definition that includes
a data type column that is not supported, you must remove that column
from the data mart definition
- Create references, or joins, between tables in the data
mart definition (if necessary).
- Designate the fact table for the data mart definition.
- Specify the table columns to load into the accelerator. Select the table in the Canvas and look at the Properties view.
click the Columns page to view a list of the
columns in that table. By default all of the columns in the table
are included in the data mart. Clear the columns that you do not want
included.
- Check the size of a data mart definition before it is deployed. You can compare a size estimate of the data mart definition
with the memory that is available on the accelerator server. If necessary,
you can change the join type of table references or omit specific
columns that are rarely or never needed to reduce required memory.
- Validate the integrity of the data mart definition. Ensure that the syntax and structure of a data mart definition
are correct and that the data mart can be safely deployed to the accelerator
server.
After you create the data mart definition, you need to
deploy and load data into the data mart.