Date 10/800: thứ 6 04-10-2013

Date 10/800: thứ 6 04-10-2013

Data Sources: Your data warehouse is likely made up of disparate data sources such as
Microsoft SQL Server, Oracle, DB2, Teradata, and so forth. Analysis Services can easily deal
with retrieving relational data from various relational databases. Data source objects contain
information needed to connect to a data source such as server name, catalog or database
name, and login credentials. You establish connections to relational servers by creating a data
source for each one.
‰ Data Source Views: When working with a large operational data store, you don’t always
want to use all the tables in the database. With Data Source Views (DSVs), you can limit the
number of visible tables by including only the tables that are relevant to your analysis. DSVs
enable you to create a logical data model upon which you build your multidimensional database.
A DSV can contain tables from one or more data sources. Data sources and DSVs are
discussed in Chapter 4.