Pritam Bondarde, it depends. Are you referring to copying tables between projects? Or are you referring to loading files from SFTP or other SaaS Applications? If you are using Datalink to copy tables between projects, then you need to make sure you are on the proper pipeline step to do the copy, otherwise you will get different results. But if you are referring to loading files, it can still do 'overwrite' or 'append' depending on what you want to do with the data load.
I hope this helps.