Hello,
I am just starting to use Snapshots. I have my primary schema MARTS, and have also configured a custom schema MARTS_STAGING which holds my staging tables. All good so far.
In my scenario, I have some non-SCD tables like DIM_EMPLOYEE that are in MARTS. I would like to create SCD2 Snapshots on these, and place them in the same schema (MARTS), not something different like MARTS_SNAPSHOT. Is that possible to do?
I’m having trouble figuring out a config block that would support that. Thank you!