I want to do an Append Flat File in S3 with Informatica BDM.
I have one flat file in my S3 directory and when I do a load, my goal is to do an append, saving the information of existing file in S3 and increasing the information with the source S3 flat file.
How can I do it?
PWX for S3 allows overwriting existing files in the S3 bucket. Append if exists is not yet supported as the only way to modify a file in Amazon S3 bucket is to first download it, then append the data and re-upload it. For large files, this operation will be quite costly in terms of network usage.