Diffrence between Concatenate and Join???
Go through this thread What is the difference between Concatenate Load and Join?
Had you search the community you would get many discussions like: Fullouter join and concatenate
Concatenate : This will only append you data with previously loaded data.
Join : Join will check you similar keys and based on that merge data.
Have a look at below post.
Please find attached file this will help you.
Retrieving data ...