The problem is, many of us hinder innovation with constraints, rules, and overall, realism. If you always take the approach that creativity will ultimately lead to a unfinished or unwanted...

I was the only technical resource on my team until I got the business to understand that one day, I won't be here. What then?

Hard to have those...

It's a tricky one for sure. I haven't myself dealt with it, but I could see it happening. To add some more insight for you. I imagined how I would...

Onto the original question. 

Do you need to reference the historic dimensional data? If not, then just update the existing record and generate no new keys. Why store data...

Lynn, this is a classic case where the dimension record is updated with new information that invalidates the fact record at the time of it's recording. He/she is asking if...

There is surely going to be an increase in more services and a need for experts with these services as time goes on. They are coming out in a rapid...

I believe the issue most run into is trying to setup parallel loading as separate batches with the parallel features enabled. Then they try to run them all in parallel...

Many schools of thought behind that one. I tend to get the logic down first to simply get something done quickly, then iterate over it for scalability later. Too many...

You can also use another term to reference specific methods as well use path locations in case you have to crawl directories. 🙂

This is just me. I view audit systems as only verbose. I think when you start trying to make your audit system do everything including making changes to the environment...

I'll just add that machine learning is learning from what is happening. It's essentially, optimizing itself. That way when the rain comes, it can learn what that means. The first...