Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

dwh interview

5 posters

Go down

dwh interview  Empty dwh interview

Post  sqlwarehouse Tue Sep 13, 2011 5:18 pm

hello there,i am very new to this forum....i have got an interview offer related to datawarehouse jobs... they asked me to give 10 minutes presentation on how would i establish the operational(i.e service) requirements for the data warehouse? any idea guys ..operational requirements ..please ...Thank you very much

sqlwarehouse

Posts : 6
Join date : 2011-09-13

Back to top Go down

dwh interview  Empty Re: dwh interview

Post  sqlwarehouse Wed Sep 14, 2011 3:15 pm

please share some ideas guys abt the above requirements

sqlwarehouse

Posts : 6
Join date : 2011-09-13

Back to top Go down

dwh interview  Empty Re: dwh interview

Post  LAndrews Wed Sep 14, 2011 4:10 pm


If you're qualified for the job (in other words, you've done the work before) - then you'll know the answer.


LAndrews

Posts : 132
Join date : 2010-05-13
Location : British Columbia, Canada

Back to top Go down

dwh interview  Empty Re: dwh interview

Post  sqlwarehouse Thu Sep 15, 2011 5:25 pm

i dont know the answer.. could you please give us some ideas ?
confused between operational and functional ....

sqlwarehouse

Posts : 6
Join date : 2011-09-13

Back to top Go down

dwh interview  Empty Re: dwh interview

Post  ian.coetzer Fri Sep 16, 2011 4:21 am

There are typically three types of reporting that can be done off of data warehouses (if they are properly designed using the kimball dimensional modeling methodology etc.)

Strategic Reporting
Analytical Reporting
Operational Reporting

Operational Reporting is the simplest in some sense - it refers to the day to day activities of a company and how to keep track of things happening at the very basic / low level.

For example - a customer phones a call centre agent, call centre agent supports the customer telephonically with something for 15 minutes.
This is an operation business evenint that could be stored in a data warehouse - with dimensions like Customer, Agent, Branch, Date and measures in a centralized fact table like TimeofCallInMinutes linking to the various dimensions and twice to the date dimension (role-playing) like call start date and call end date.

Then one can neatly create a report by grouping the measure (timeOfCall) by branch / agent / state date - and ordering by total time spent per customer to see which call centres - or event agents - on average are more effecient - IF it is measured by the time they spend with customers - and maybe another flag / measure which indicates whether the customer was happy or not. - which could also be summed etc.
ian.coetzer
ian.coetzer

Posts : 57
Join date : 2010-05-31
Age : 43
Location : South Africa

Back to top Go down

dwh interview  Empty Re: dwh interview

Post  sqlwarehouse Fri Sep 16, 2011 5:21 am

Hi Ian, thanks for ur reply. Iam sorry, the question is about operational requirements for data warehouse. you may have read as operational reporting.
...any idea about operational requirements????. Thanks for ur help.

sqlwarehouse

Posts : 6
Join date : 2011-09-13

Back to top Go down

dwh interview  Empty Re: dwh interview

Post  ian.coetzer Fri Sep 16, 2011 5:38 am

Not sure what that would refer to.
Perhaps that should be reworded to technical requirements? which technology to use? ETL process - loading into a staging database - then moving data to a conforming database where the data is cleaned up a bit? nulls etc. removed - then loading only changes and new records into the data warehouse using clever techniques such has hashing etc.

also operationally the ETL process should write audit trails every time an SSIS package etc. runs? to log when it started / stopped datetime stamp + # records inserted # records updated etc.
ian.coetzer
ian.coetzer

Posts : 57
Join date : 2010-05-31
Age : 43
Location : South Africa

Back to top Go down

dwh interview  Empty Re: dwh interview

Post  sqlwarehouse Fri Sep 16, 2011 1:48 pm

anyone ....about operational requirements for the dataware house....

how about these.. can i say these following are operational requirements ....

-Requirement Gathering
-Physical Environment Setup
-Data Modeling
-ETL
-OLAP Cube Design
-Front End Development
-Report Development
-Performance Tuning
-Query Optimization
-Quality Assurance
-Rolling out to Production
-Production Maintenance
-Incremental Enhancements

sqlwarehouse

Posts : 6
Join date : 2011-09-13

Back to top Go down

dwh interview  Empty Re: dwh interview

Post  BoxesAndLines Fri Sep 16, 2011 4:32 pm

Sorry, I don't know what operational requirements are either.
BoxesAndLines
BoxesAndLines

Posts : 1212
Join date : 2009-02-03
Location : USA

Back to top Go down

dwh interview  Empty Re: dwh interview

Post  sqlwarehouse Sat Sep 17, 2011 4:15 pm

anyone ...lots of gurus there

sqlwarehouse

Posts : 6
Join date : 2011-09-13

Back to top Go down

dwh interview  Empty Re: dwh interview

Post  ngalemmo Sun Sep 18, 2011 3:14 am

My guess is they are referring to one of two things:

1. What needs to occur within the operations team (i.e. the people who keep the machines running) (backups, preventive maintenance, database reorgs, etc)
or
2. Establishing service level metrics for the environment (response times, availibility, etc...)

Most likely the latter. Why don't you simply ask them?
ngalemmo
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

http://aginity.com

Back to top Go down

dwh interview  Empty Re: dwh interview

Post  Sponsored content


Sponsored content


Back to top Go down

Back to top


 
Permissions in this forum:
You cannot reply to topics in this forum