"Eugene Frolov" <john@alice.ru> wrote in message
news:%23om6%23VntEHA.2536@TK2MSFTNGP11.phx.gbl...
> 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?
>
>

> 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.
> --
> 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.
>
> "Eugene Frolov" <john@alice.ru> wrote in message
> news:%23om6%23VntEHA.2536@TK2MSFTNGP11.phx.gbl...
> > 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?
> >
> >
>
>

"Eugene Frolov" <john@alice.ru> wrote in message
news:OMgGTkztEHA.2788@TK2MSFTNGP09.phx.gbl...
> Thank you for answer, but: what is a PAG? I'm reading ALL 3 guides comes
> with MS BI Accelerator (Development, Deployment and Maintenance).
>
> "Dave Wickert [MSFT]" <dwickert@online.microsoft.com> ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ ×
> ÎÏ×ÏÓÔÑÈ ÓÌÅÄÕÀÝÅÅ: news:OHtoAPttEHA.2128@TK2MSFTNGP11.phx.gbl...
> > 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.
> > --
> > 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.
> >
> > "Eugene Frolov" <john@alice.ru> wrote in message
> > news:%23om6%23VntEHA.2536@TK2MSFTNGP11.phx.gbl...
> > > 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?
> > >
> > >
> >
> >
>
>