A relational target schema is one that contains relational data objects such as tables, views, materialized views, and sequences. All the warehouse data is stored in these objects.
After you finish designing your data warehouse or data mart, you are ready to design your target system. This chapter shows you how to create relational data objects. Relational objects include tables, views. materialized views, sequences, external tables, and user-defined objects (object types, Varrays, and nested tables).
System requirements vary for RDBMS (see the Oracle Hyperion Enterprise Performance management System Installation Start Here Guide), and you must compose a database connection string and provide log on credentials to navigate your relational hierarchy. You can also connect to level 2 or level 4 JDBC RDBMS using other relational data objects (SQL Spreadsheet, freeform grid, relational drill-through and Integration Services drill-through).
Relational data objects include tables, views, materialized views, and sequences. To create tables, views, and materialized views, use the Data Object Editor. Use the Create Sequence dialog box to create sequences.
Creating Relational Data Objects in SQL Server and IBM DB2 UDB
SQL ServerおよびIBM DB2 UDBにおけるリレーショナル・データ・オブジェクトの作成
Relational data objects include tables, views, materialized views, and sequences. You may have already imported some existing target objects. To create additional data objects, see "Creating Relational Data Objects". You can define additional structures pertaining to relational objects such as constraints, indexes, and partitions.
The Data Object Editor Palette displays icons for the type of data objects that you can drag and drop onto the canvas. Some icons in the palette may be disabled. The Palette, like the Explorer, is synchronized with the canvas. The data objects that are enabled in the Palette depend on the currently active tab on the canvas. For example, when the Relational tab is currently active in the canvas, all the relational data objects in the Palette are enabled.
Exemplele au rolul de a te ajuta să traduci cuvinte sau expresii corect si adaptat la context. Nu sunt selectate sau validate manual, așadar pot conține termeni inadecvați. Te rugăm să raportezi exemplele pe care le consideri inadecvate. Traducerile vulgare sau colocviale sunt în general marcate cu roșu sau cu portocaliu.