Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear all,
I have come across 2 techiniques for data modelling - join and concat. Can anyone please help me understand when to use which and the advantages and pitfalls of each......
Thanks
Hi
To put it simply, Concat adds new rows to the table, while Join adds new columns.
By way of example, use concat when combining rows from multiple tables or files, or combining (for eg) sales and budgets into a single fact table.An example of a join would be adding lookup information, such as adding in a customer name to a source that contains the customer ID.
Hope that helps
Jonathan
(These are simple examples. Strictly speaking, outer joins can result in more rows and joins can also cause a source row to be replicated if the join condition is not unique).