It will require a little bit of work, but yes...if you can identify the partition it belongs to, you should be able to dynamically build the refresh query in SSIS...

Yes, assuming it is possible to add other dimension keys into the new fact table, it should always be your goal to have all the relevant (conformed) dimensions linked to...

True, I see you can only use table hints and not query hints. why are you trying to enforce the parallelism?

What have you tried and what are you struggling with? Posting the details of your attempts and the output vs. what you're trying to get as output will help us...

Your best option would probably be to create a view (with the table hint), and then use that in SSAS.

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

No worries, and only if you really want to 🙂

The pattern to do that is similar to inventory snapshots, where you'd like to return the last record of each product/item. More info on how to do it here:

Yes, it is possible to do that in ADF. I have a series of blog posts on the topic, if you're interested: https://martinschoombee.com/2022/02/15/working-with-oauth-2-0-apis-in-azure-data-factory-a-series/

We need more information to try and help. Can you post screenshots of your copy activity and its properties, as well as the current and expected output?

Ok, now that I'm not confused anymore 🙂

I am familiar with Tim's post, and wish that Microsoft took the temporal table feature a little further past its initial implementation. My...

I think you're getting confused with some of the terminology (or I am). Type-1 dimensions do not track changes and are not temporal. Type-2 dimensions track changes and are temporal...

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

If you make all of our fact tables temporal, then any type-2 change in a dimension will have to drive a change to the fact table(s) as well. You can...

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

There's a lot to unpack here, so let me start with a few thoughts and clarifying questions:

To answer your primary question of "Is it ok to update Fact table records?":...

We've all been there...keep asking questions 🙂

Assuming I add the AccountType attribute to my Account dimension, should I also add the other Account attributes to the same dimension?  It feels like I've just moved my...