In v20.10.43, I’ve come across a bunch of auto-generated views with a _BCV suffix.
Are they used for merged (incremental?) loading in the next layer, or what’s the purpose of these views?
Why do they need to be redeployed whenever I do a managed deployment?
And why does the SQL Clean Up Wizard delete them when they’re being used?
(I haven’t tested if this could happen in a v6284.1 MDW)
Best answer by Thomas LindView original