Hi,
I have a single transaction table with a bunch of IDs that needs to be joined with 4 other dimension tables in order to pull data such as product name, market name etc. (joining on id numbers)
I'm currently connected to a SQL Server database using the "in-database" tool and would therefore require to use "Join In-DB".
What is the best way to go about this?
Thanks in advance!
afk
Solved! Go to Solution.
Hi @akasubi,
It is simply a case of joining one table at a time, so for your 4 tables to join you would have 4 Join In-DB tools one after the other with In-DB Input tools selecting each of the 4 tables to go into one of the join tools.
It may be easier/quicker to hardcode these joins using a SQL query in a single input tool.
Sam :)
Hi Sam,
Thanks for your prompt reply.
Initially I thought of doing it this way but was wondering whether there was a more "efficient" method. But I guess this is the best solution :) .