Advice on if to use Join or concatenate ?

[Anonymous]

I have a table A in my application with 31 columns , now i have to integrat another table B with 25 columns into it, most of the columns between them are the same, I want to retain all the data of table A, and add all the new data from table B...

Thanks

B

[Oleg_Troyansky]

Concatenation is most likely the "cleaner" way of doing it. Joining may introduce issues of duplication if your data might be duplicated in one of the tables...

[vijay_iitkgp]

If most of the columns are same then it is always better to use concatenation.

Regards

VIjay

[#4]

Hi Balraj,

I would say, if most of the fields are same between the tables use concatenate.

But, make sure you use the keyword Concatenate between the tables in the script.Or else it will result in creating

synthetic key and you will end up having three tables in the data model.

Note : Join adds columns, concatenate adds rows

Hope this helps,

Regards,

Snehal Nabar

[#5]

Hi Balraj,

Please mark this post as answered,if it has solved your query.

Regards,

Snehal Nabar

[sujeetsingh]

Take care it may lack some linking is colomns differ