dwh interview

View previous topic View next topic Go down

dwh interview

Post  sqlwarehouse on 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

View user profile

Back to top Go down

Re: dwh interview

Post  sqlwarehouse on Wed Sep 14, 2011 3:15 pm

please share some ideas guys abt the above requirements

sqlwarehouse

Posts : 6
Join date : 2011-09-13

View user profile

Back to top Go down

Re: dwh interview

Post  LAndrews on 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

View user profile

Back to top Go down

Re: dwh interview

Post  sqlwarehouse on 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

View user profile

Back to top Go down

Re: dwh interview

Post  ian.coetzer on 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.
avatar
ian.coetzer

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

View user profile

Back to top Go down

Re: dwh interview

Post  sqlwarehouse on 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

View user profile

Back to top Go down

Re: dwh interview

Post  ian.coetzer on 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.
avatar
ian.coetzer

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

View user profile

Back to top Go down

Re: dwh interview

Post  sqlwarehouse on 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

View user profile

Back to top Go down

Re: dwh interview

Post  BoxesAndLines on Fri Sep 16, 2011 4:32 pm

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

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

View user profile

Back to top Go down

Re: dwh interview

Post  sqlwarehouse on Sat Sep 17, 2011 4:15 pm

anyone ...lots of gurus there

sqlwarehouse

Posts : 6
Join date : 2011-09-13

View user profile

Back to top Go down

Re: dwh interview

Post  ngalemmo on 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?
avatar
ngalemmo

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

View user profile http://aginity.com

Back to top Go down

Re: dwh interview

Post  Sponsored content


Sponsored content


Back to top Go down

View previous topic View next topic Back to top

- Similar topics

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