Simply put,
"Append" is for vertical data combination.
"Merge" is for horizontal data combination.
For merge, always choose the bigger data set as in memory and merge a smaller data set, which can save some time.
PS: also choose many:many option.
