Creating a Cube - Informatica

To create a cube:

  1. From the Target Designer, click Targets > Create Cube.
  2. Enter the following information:
    • Cube name. The cube name must be unique in a folder.
    • Cube type. Choose Normalized or Non-normalized. Normalized dimensions must have a normalized cube.
    • Similarly, non-normalized dimensions must have a non-normalized cube.
    • Database type. The database type for the cube must match the database type for the dimensions in the cube.
  3. Click Next.
  4. Specify the dimensions and hierarchies to include in the cube.
  5. Click Next.
  6. Add measures to the cube.
  7. You can copy columns from source tables or add new columns. Measure names must be unique within a fact. Level names must be unique within each cube.

  8. Add a name for the fact table.
  9. Click Finish.
  10. The Designer adds the cube and fact tables to the workspace.

All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd DMCA.com Protection Status

Informatica Topics