Data Warehousing question

I asked some of this question in another group so pardon my cross posting.
Im rather bored right now and really curios about this.
Do most of the BI folks do the technical stuff on they're own, or do they
have the technical people do it for them? Is it common to have someone doing
the technical but not alot of business involvement? If I were to go from
being a DBA to a DW guy tomorrow, would I be thrown much more in the mix
with the business folks? I never thought about this but I would have to
imagine it to be the case.
TIA, ChrisR
Sorry...

> Do most of the BI folks do the technical stuff on they're own, or do they
> have the technical people do it for them? Is it common to have someone
> doing the technical but not alot of business involvement?
This was all in regards to Data Warehousing.
"ChrisR" <noemail@.bla.com> wrote in message
news:e3e5izQpFHA.3568@.TK2MSFTNGP10.phx.gbl...
>I asked some of this question in another group so pardon my cross posting.
>Im rather bored right now and really curios about this.
>
> Do most of the BI folks do the technical stuff on they're own, or do they
> have the technical people do it for them? Is it common to have someone
> doing the technical but not alot of business involvement? If I were to go
> from being a DBA to a DW guy tomorrow, would I be thrown much more in the
> mix with the business folks? I never thought about this but I would have
> to imagine it to be the case.
> TIA, ChrisR
>
>

Data Warehousing question

I asked some of this question in another group so pardon my cross posting.
Im rather bored right now and really curios about this.
Do most of the BI folks do the technical stuff on they're own, or do they
have the technical people do it for them? Is it common to have someone doing
the technical but not alot of business involvement? If I were to go from
being a DBA to a DW guy tomorrow, would I be thrown much more in the mix
with the business folks? I never thought about this but I would have to
imagine it to be the case.
TIA, ChrisRSorry...
> Do most of the BI folks do the technical stuff on they're own, or do they
> have the technical people do it for them? Is it common to have someone
> doing the technical but not alot of business involvement?
This was all in regards to Data Warehousing.
"ChrisR" <noemail@.bla.com> wrote in message
news:e3e5izQpFHA.3568@.TK2MSFTNGP10.phx.gbl...
>I asked some of this question in another group so pardon my cross posting.
>Im rather bored right now and really curios about this.
>
> Do most of the BI folks do the technical stuff on they're own, or do they
> have the technical people do it for them? Is it common to have someone
> doing the technical but not alot of business involvement? If I were to go
> from being a DBA to a DW guy tomorrow, would I be thrown much more in the
> mix with the business folks? I never thought about this but I would have
> to imagine it to be the case.
> TIA, ChrisR
>
>

Data Warehousing question

I asked some of this question in another group so pardon my cross posting.
Im rather bored right now and really curios about this.
Do most of the BI folks do the technical stuff on they're own, or do they
have the technical people do it for them? Is it common to have someone doing
the technical but not alot of business involvement? If I were to go from
being a DBA to a DW guy tomorrow, would I be thrown much more in the mix
with the business folks? I never thought about this but I would have to
imagine it to be the case.
TIA, ChrisRSorry...

> Do most of the BI folks do the technical stuff on they're own, or do they
> have the technical people do it for them? Is it common to have someone
> doing the technical but not alot of business involvement?
This was all in regards to Data Warehousing.
"ChrisR" <noemail@.bla.com> wrote in message
news:e3e5izQpFHA.3568@.TK2MSFTNGP10.phx.gbl...
>I asked some of this question in another group so pardon my cross posting.
>Im rather bored right now and really curios about this.
>
> Do most of the BI folks do the technical stuff on they're own, or do they
> have the technical people do it for them? Is it common to have someone
> doing the technical but not alot of business involvement? If I were to go
> from being a DBA to a DW guy tomorrow, would I be thrown much more in the
> mix with the business folks? I never thought about this but I would have
> to imagine it to be the case.
> TIA, ChrisR
>
>

data warehousing olap

cananyone help me regarding data warehousing & Business Intelleigence . Dow any one have notes or links to download details & tutorials regarding Info Cubes
regards
raj chokshiInfoc Cubes is an SAP centric term, are you interested in SAP business warehousing or in data warehousing? If you are interested in DW, I reccomend you start by reading Kimball's articles: http://intelligententerprise.com/ports/search_dw_fund.shtml

If you are interested in BW, you might start at the SAP developer network here https://www.sdn.sap.com/

HTH|||Hi

As u referred me the SDN Site Link. I did get connected & registered my self but to my dis-satisfaction. I was not able to get some seroius content regarding BW . I do have the help .pdf file but it is huge & the links aregarding the learning procedure is also not clear. It would be more profitable if you have any such kind of content relating to BW to share with me .

regards
raj|||I'm fairly new to SAP BW, from what I hear they have forums there that are supposed to be pretty good. Another place to try is the SAP Service marketplace at https://websmp204.sap-ag.de/~SAPIDP/002006825000000234912001E

HTH

Data Warehousing Learning Sample

Greetings,
I'm new with data warehousing. Just wondering, do any of you know of a
free sample/example that would help me learn the ABC's of data
warehousing?
The SQL 2000 sample is only available with SQL Enterprise..
Thanks in advance,
Don
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
The Analysis Services installation comes with a sample database called Food
Mart 2000 which is an OLAP database that sits on top of an .mdb file. Is
this the one that you have already investigated?
Jay Nathan, MCP
http://www.jaynathan.com/blog
"don larry" <donlarry17@.hotmail.com> wrote in message
news:O4t01EM3EHA.3932@.TK2MSFTNGP12.phx.gbl...
> Greetings,
> I'm new with data warehousing. Just wondering, do any of you know of a
> free sample/example that would help me learn the ABC's of data
> warehousing?
> The SQL 2000 sample is only available with SQL Enterprise..
> Thanks in advance,
> Don
> *** Sent via Developersdex http://www.codecomments.com ***
> Don't just participate in USENET...get rewarded for it!
|||Greetings,
Hi Jay, it is a great sample. Just what I was looking for.
Thank you,
Don
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!

Data warehousing design

Hi

We are starting with designing a datawarehouse for my company. I have done some reading on the concepts and steps involved, but what I am seriously lacking is some examples. I'd like to read through some real examples of data warehouses that worked including the full design diagrams.
Can anyone direct me to some good sites for this?

Thanks,
TeaaZAIf you are building a true data warehouse, then get the books written by Bill Inmon. If you are building a small data mart, then you might consider Kimball's books.

Data warehousing - Design

I'm designing data wareouse where I=B4m taking Data from an=20
operational Database, I=B4m creating dimension tables and=20
facta tables, my question is following.
When creating dimension tables I=B4m sometimes taking=20
column from tables in the operational database where=20
there is no indexing, should I create index for the=20
column in the data warehouse ?.
When creating facta tables and dimension tables for=20
Analyser services should I have dimension tables with=20
primary keys, and facta with foreign keys to the=20
dimension tables.
Does somone knows about some good article for designing=20
Data warehouse for Analyser services
Looking forward to hear from you
Regards
J=F3n SveinssonTry these
http://www.microsoft.com/technet/tr...part5/c2061.asp
http://www.ralphkimball.com/html/articles.html
HTH
Ray Higdon MCSE, MCDBA, CCNA
--
"Jn Sveinsson" <jon@.nordural.is> wrote in message
news:035701c3fab5$f1f389c0$a401280a@.phx.gbl...
I'm designing data wareouse where Im taking Data from an
operational Database, Im creating dimension tables and
facta tables, my question is following.
When creating dimension tables Im sometimes taking
column from tables in the operational database where
there is no indexing, should I create index for the
column in the data warehouse ?.
When creating facta tables and dimension tables for
Analyser services should I have dimension tables with
primary keys, and facta with foreign keys to the
dimension tables.
Does somone knows about some good article for designing
Data warehouse for Analyser services
Looking forward to hear from you
Regards
Jn Sveinsson

Data Warehousing

HAI
i have read about few pages in Microsoft dataware housing toolkit by ralph
kimball.i find it little difficult and vague to understand the concepts.so i
kindly request anybody who have worked with dataware housing to recommened
me a book to get a clear picture to start with and then to concentrate on
design part.
thank youmaybe try this book:
Microsoft SQL Server 2005 Analysis Services Step by Step
but I don't know what is its content.
"vidhya" <vidhya@.chellasoft.com> wrote in message
news:u4MZEqxrGHA.4512@.TK2MSFTNGP02.phx.gbl...
> HAI
> i have read about few pages in Microsoft dataware housing toolkit by ralph
> kimball.i find it little difficult and vague to understand the concepts.so
> i kindly request anybody who have worked with dataware housing to
> recommened me a book to get a clear picture to start with and then to
> concentrate on design part.
> thank you
>|||hi, i'm thangesh
i'want datawarehousing in informatica project and design pls give
datails and how to prefer resume and interview technical questions.
*** Sent via Developersdex http://www.codecomments.com ***

data warehousing

We have some old data that we are not using, it's taking so much space for
no reason, we want to keep them seperately from the new data so we 're
planning to insert them to a seperate table and still make them accessible
by the customers whenever they want to access the arcieved data. Now I
really need your advice on this. What is the best way to do this? There 's 8
million data on this table, how do I implement this arcieving system?
Thank you.I would put it in a separate database... that way it could be backed up and
restored separately... It would also make it easier to move to another
server if (later) you decided to doso.
--
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Fulya Erol" <ferol@.no.nospam.mezun.com> wrote in message
news:eU3qGrAwDHA.3744@.TK2MSFTNGP11.phx.gbl...
> We have some old data that we are not using, it's taking so much space for
> no reason, we want to keep them seperately from the new data so we 're
> planning to insert them to a seperate table and still make them accessible
> by the customers whenever they want to access the arcieved data. Now I
> really need your advice on this. What is the best way to do this? There 's
8
> million data on this table, how do I implement this arcieving system?
> Thank you.
>

Data warehouse data refresh/update

Hello,
Im a member of a team planning a data warehousing project. We have multiple data sources which are aggregated in a staging area. This is then denormalised and imported into the datawarehouse database.
I am looking at ideas for incremental data refresh, rather than a drop and re-import of all data. This would allow us to have historic data.
Does anyone have any tips that might be helpful for detecting changes in the source data for import? We have had some bad experiences with triggers on our source database in the past, so would rather not use these. I have considered replication and log sh
ipping, but these just give a replica of the source data and does not flag the updated/new data.
Any help would be greatly appreciated.
Thanks.
Ben.
Look in SQL Books Online for CHECKSUM_AGG to identify changes in a table. The difficulty then is in trying to identify what has changed. Another route is to try and identify fields within the production data that will identify when it was last changed. Ty
pically these tend to be datetime, timestamp or rowversion data types.
If you keep production keys in your fact table as additional attributes then this will give you another option for identifying new data.
"Ben" wrote:

> Hello,
> Im a member of a team planning a data warehousing project. We have multiple data sources which are aggregated in a staging area. This is then denormalised and imported into the datawarehouse database.
> I am looking at ideas for incremental data refresh, rather than a drop and re-import of all data. This would allow us to have historic data.
> Does anyone have any tips that might be helpful for detecting changes in the source data for import? We have had some bad experiences with triggers on our source database in the past, so would rather not use these. I have considered replication and log
shipping, but these just give a replica of the source data and does not flag the updated/new data.
> Any help would be greatly appreciated.
> Thanks.
> Ben.
|||Timestamp your source data when it gets changed. That is definately the best way.
Rgards
Jamie
"Ben" wrote:

> Hello,
> Im a member of a team planning a data warehousing project. We have multiple data sources which are aggregated in a staging area. This is then denormalised and imported into the datawarehouse database.
> I am looking at ideas for incremental data refresh, rather than a drop and re-import of all data. This would allow us to have historic data.
> Does anyone have any tips that might be helpful for detecting changes in the source data for import? We have had some bad experiences with triggers on our source database in the past, so would rather not use these. I have considered replication and log
shipping, but these just give a replica of the source data and does not flag the updated/new data.
> Any help would be greatly appreciated.
> Thanks.
> Ben.

Data warehouse data refresh/update

Hello,
Im a member of a team planning a data warehousing project. We have multiple
data sources which are aggregated in a staging area. This is then denormalis
ed and imported into the datawarehouse database.
I am looking at ideas for incremental data refresh, rather than a drop and r
e-import of all data. This would allow us to have historic data.
Does anyone have any tips that might be helpful for detecting changes in the
source data for import? We have had some bad experiences with triggers on o
ur source database in the past, so would rather not use these. I have consid
ered replication and log sh
ipping, but these just give a replica of the source data and does not flag t
he updated/new data.
Any help would be greatly appreciated.
Thanks.
Ben.Look in SQL Books Online for CHECKSUM_AGG to identify changes in a table. Th
e difficulty then is in trying to identify what has changed. Another route i
s to try and identify fields within the production data that will identify w
hen it was last changed. Ty
pically these tend to be datetime, timestamp or rowversion data types.
If you keep production keys in your fact table as additional attributes then
this will give you another option for identifying new data.
"Ben" wrote:

> Hello,
> Im a member of a team planning a data warehousing project. We have multipl
e data sources which are aggregated in a staging area. This is then denormal
ised and imported into the datawarehouse database.
> I am looking at ideas for incremental data refresh, rather than a drop and
re-import of all data. This would allow us to have historic data.
> Does anyone have any tips that might be helpful for detecting changes in the sourc
e data for import? We have had some bad experiences with triggers on our source data
base in the past, so would rather not use these. I have considered replication and l
og
shipping, but these just give a replica of the source data and does not flag the updated/new
data.
> Any help would be greatly appreciated.
> Thanks.
> Ben.|||Timestamp your source data when it gets changed. That is definately the best
way.
Rgards
Jamie
"Ben" wrote:

> Hello,
> Im a member of a team planning a data warehousing project. We have multipl
e data sources which are aggregated in a staging area. This is then denormal
ised and imported into the datawarehouse database.
> I am looking at ideas for incremental data refresh, rather than a drop and
re-import of all data. This would allow us to have historic data.
> Does anyone have any tips that might be helpful for detecting changes in the sourc
e data for import? We have had some bad experiences with triggers on our source data
base in the past, so would rather not use these. I have considered replication and l
og
shipping, but these just give a replica of the source data and does not flag the updated/new
data.
> Any help would be greatly appreciated.
> Thanks.
> Ben.

data ware housing

Hai
i have just started to learn about the concepts of dataware housing. i
came to know there are about 5 services in data warehousing.
Namely, 1.Analytical services 2.Integerating services 3 Data Mining 4
Notification services and 5 Reporting services.my doubt i that is there any
order of studying these services or just start with any of the services and
complete one by one.
Thank youYou are mentioning the tools and leaving out the concepts. Here is the order
you should probably focus your studies:
1) Dimensional Modeling
2) ETL Concepts (type 1, type 2, etc.)
3) SSIS (integration services)
4) SSAS (analysis services)
5) SSRS (reporting services)
6) Notification Services
-=Steve
"vidhya" wrote:

> Hai
> i have just started to learn about the concepts of dataware housing. i
> came to know there are about 5 services in data warehousing.
> Namely, 1.Analytical services 2.Integerating services 3 Data Mining 4
> Notification services and 5 Reporting services.my doubt i that is there an
y
> order of studying these services or just start with any of the services an
d
> complete one by one.
>
> Thank you
>
>