Forum Discussion

FZOU's avatar
FZOU
Icon for Helper IV rankHelper IV
2 years ago

Best choice to build dimension

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 🙂 

1 Reply

  • miguel's avatar
    miguel
    Icon for Community Admin rankCommunity Admin

    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.