It would be pretty tricky to get it working like this, and would probably be more complex than you would like...in my opinion.

You can send data via an API request...

Not sure I understand why you would want to do that...can you elaborate on the use case? What problem are you trying to solve?

I think you're crossing lines with another post maybe.

It's impossible to comment whether your approach is a sensible way without the necessary context of what the design looks like and...

I personally don't like system-versioned tables because they require a datetime type, and you don't control the values that are being inserted. I prefer to do that myself with effective...

My personal preference is to land Dates (or Date/Time) fields as text (varchar) in the staging area if I don't trust the source...or if I anticipate possible conversion issues.

The pro...

(see latest post)

• This reply was modified 3 months, 3 weeks ago by  Martin Schoombee.

I haven't and can unfortunately not comment on it, but Joe is well-known and respected for his work with the Kimball Group. It would definitely not hurt to read his...

I wouldn't change any configuration properties unless I have a better understanding of the root cause. If the CPU is high, then it is likely due to either a refresh...

How do I track for changes in Cost/Price? Just add a trigger to Product[UnitPrice] and Purchase[UnitCost] and maybe call a stored procedure from the trigger to (1) find all...

• This reply was modified 8 months, 1 week ago by  Martin Schoombee.

I'm not sure about the detail in the physical book as it's been a while since I've read it, but here is the official on the Kimball website: https://www.kimballgroup.com/data-warehouse-business-intelligence-resources/kimball-techniques/dimensional-modeling-techniques/timespan-fact-table/

As you...

(While I'm at it, say I have a bunch of recurring business costs, like rent and gas and the like. I can sum those by quarter (say) and then...

• This reply was modified 8 months, 1 week ago by  Martin Schoombee.

Like, one starter consists of something like 7 parts water, 4 parts flour, 3 parts potato starch by volume). And starter is listed as an ingredient... Do I create...

If I have some time, I plan to do something about that next year. Stay tuned!

This is a tricky modeling question, and one that is difficult to answer without a lot of context and spending some time considering all the options (and side-effects of those...

• This reply was modified 8 months, 1 week ago by  Martin Schoombee.
• This reply was modified 8 months, 1 week ago by  Martin Schoombee.
• This reply was modified 8 months, 1 week ago by  Martin Schoombee.

Can you provide some more details around the error-handling in your PowerShell script? I have found in the past that the meaningful part of the error messages aren't always visible...