BI Accelerator: multiply source databeses

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Eugene Frolov - 20 Oct 2004 08:21 GMT

Hi All!

I'm trying to use MS BI Accelerator for creating DW which must contain data
from different sources. Every source is our company departmnet standard
database. I'm looking for best practice for collecting fact and dim data
from this databases in BI Acc staging database, i.e. creating Source Data
ETLM process using Master_Import and its sub - DTS packages with mimimal
re-writing of its. For example, I need to get customers for Dim_Customer_Std
dimension table from Department_1, then Department_2 and so on for other
dept's and dim's. Fact table must be populated the same way - sales data
from Department_1 must be consolidated with Department_2 ...

What is the best way to do so: create a different sub-packages for every
department and then add Execute Package task into Master_Import package or
exist another way?

Reply to this Message

Dave Wickert [MSFT] - 20 Oct 2004 19:36 GMT

If you read the PAG, you will see that the Master Import packages were
design as a convienence for customers wanting to load from flat files. We
fully expected that customers will need to load the staging database with
their own data (possibly from multiple data sources). You need to implement
that piece of the system yourself, i.e. come up with your own "Master
Import" where the data comes from your own data sources. Then you plug that
in place of Master Import. The PAG also discusses ways that you could make
simple changes to the Master Import packages if what you want to do is
similar to what Master Import does -- in your case, this does not seem to
apply, so you would just replace Master Import with your own system -- then
Master Update takes the data from the staging database and moves it through
the system from there.

Hope that helps.

Signature

Dave Wickert [MSFT]
dwickert@online.microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.

> Hi All!
>
[quoted text clipped - 11 lines]
> department and then add Execute Package task into Master_Import package or
> exist another way?

Reply to this Message

Eugene Frolov - 21 Oct 2004 07:42 GMT

Thank you for answer, but: what is a PAG? I'm reading ALL 3 guides comes
with MS BI Accelerator (Development, Deployment and Maintenance).

> If you read the PAG, you will see that the Master Import packages were
> design as a convienence for customers wanting to load from flat files. We
[quoted text clipped - 36 lines]
> > department and then add Execute Package task into Master_Import package or
> > exist another way?

Reply to this Message

Dave Wickert [MSFT] - 21 Oct 2004 18:51 GMT

That is what we call the PAG (Prescriptive Architecture Guides).

Signature

Dave Wickert [MSFT]
dwickert@online.microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.

> Thank you for answer, but: what is a PAG? I'm reading ALL 3 guides comes
> with MS BI Accelerator (Development, Deployment and Maintenance).
[quoted text clipped - 47 lines]
> or
> > > exist another way?

Reply to this Message