1 Reply Latest reply on Jan 11, 2017 6:09 AM by Mahendra_Rajpoot

    Sequential Merge Option for Flat Files

    Seasoned Veteran

      Hi All,

       

      I am trying to use sequential merge option to merge three files and create one file.

       

      I have used "Append if exists" option and was able to create one file with all three files data.

       

      But when I select below options in Session properties for sequential merge its not working.

       

      Merge Type: Sequential Merge

      Merge File Directory: server path

      Merge file Name: abc.csv

      Append if exists: unchecked this option since mentioned merge type as Sequential merge.

       

      If anyone of you have worked with Sequential merge option. Please let me know the steps that are needed.

       

      Thanks

      Dave

        • 1. Re: Sequential Merge Option for Flat Files
          New Member

          Hi Dave,


          Sequential Merge
          – Informatica creates one output file for each partition and sequentially merge them to a single file when the session completes.

           

          I think you need to partition the session for merge to work and flat file only supports pass through partitioning.

           

          Even I have not tried this, but read it in some blog. May be this will help.

           

          Thanks,

          Mahendra