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 2 years, 7 months ago by  Martin Schoombee.
• This reply was modified 2 years, 7 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 2 years, 7 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...

Yes, typically you would have the account type as an attribute in the Account dimension.

The main consideration would be if other fact tables need to be associated with the account...

Good to know, thank you 🙂

YESYESYESYESYES... Second Execute Process task working as well!!!!

I had the wrong freakin' switch!

I hate it when I spend so much time trying to troubleshoot something and it turns out...

I still think you would be much better off using a script task - where you can embed the code or import the code - or just add the...

Yeah...I would try unrestricted for the local machine (not user) too, if that's an option.

The only other thing I can try to think of here is to run Visual Studio as admin. Even with your local admin permissions, the VS process may not have...

Hmmm...your PS script might not even be initiated at all.

What is your local PS execution policy, and is the account you're using a local administrator?