Need Dynamic SQL stored procedure

[sudhav]

Hi Team 

I have config table below

fact)Transaction is fact table and remaining are dim tables , i want to joijn all of the with fact table and need to get a single table and mapping columns also i mentioned in config table,Now i am taking this config table into lookup activity and reading all the values.

in foreach i have taken copy data activity and used dynamic sql stored proc like below

imported parameters also in stored proc.

Now my question is, if i run it, 5 different tables are forming in destination instead of 1 single table, I want 1 single table as result,is there any dynamic stored proc to addition that using for loop or any help in this.

TIA

[Anonymous]

Hi @sudhav ,
Thanks for using Fabric Community.
Can you please provide me with more information regarding what are you trying to acheive here? What is the stored procedure query used in the source actually doing? What is the destination given for the copy data activity? It would be more helpful if you can provide the screenshots.

Thank you

[Anonymous]

Hi @sudhav ,

We haven’t heard from you on the last response and was just checking back to see if you can provide the details asked in the above comment. Please let us know if you have any further queries.

[Anonymous]

Hi @sudhav ,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. Please let us know if you have any other queries.