You may want to start by conforming facts. Basically, documenting your 4
databases and researching what columns and data are the same in all of the
databases

--
Sincerely,
John K
Knowledgy Consulting
www.knowledgy.org

Atlanta's Business Intelligence and Data Warehouse Experts


"Ed" <Ed@discussions.microsoft.com> wrote in message
news:CD21EB5F-6FA2-422B-A115-CDCC5D5910AD@microsoft.com...
> hi,
> I am interested in building a DW for my company. As usual, we have 4
> different systems which holds different applications. I would like to
> know
> what is the first step of buidling the DW? Retrieve the columns / data
> that
> we need? Any good link to view?
>
> Thanks so much
>
> Ed