Reply to post:

So much data, so little time: How to not flip your wig processing it

Anonymous Coward
Anonymous Coward

Not sure I agree with not doing over night jobs.

I've built data warehouses in my last 3 jobs for finance reporting joining the data from the finance application and CRM systems and set them up to run first thing in the morning, all the data is available and I can answer any question on the data within minutes, summaries are also a doddle as cutting the data is a simple query. I'm sure there are examples where you would need "live" data but a snapshot at the end of the previous day is usually enough for most reporting requirements. I just don't see the benefit of direct connections where using an output and loading that in works just as well. This is just my experience so others may have a different opinion.

POST COMMENT House rules

Not a member of The Register? Create a new account here.

  • Enter your comment

  • Add an icon

Anonymous cowards cannot choose their icon

SUBSCRIBE TO OUR WEEKLY TECH NEWSLETTER

Biting the hand that feeds IT © 1998–2019