Best choice to build dimension

[FZOU]

Hello,

I have a delta table Product in my lakehouse  in fabric, now i want to build my dimension Product in my warehouse, so i need to move the delta table from my lakehouse to my warehouse and do some transformation i know that i can achieve this with sql stored procedure,dataflow gen2, data factory etc... : 

My question is what is the best way to do it what is recommanded in this case ?

thank you everyone for the help 🙂 

[miguel]

The definition of "the best" is subjective to every user. All options that you've listed are valid and you can choose whatever will work best for you.

If you have certain questions that will help you determine what's the best tool for you, feel free to share those.