9 Replies Latest reply: Oct 20, 2010 6:15 PM by Partha Patra RSS

    Create monthly reports from same file

    Partha Patra

      Hi,

      I am looking out for the best practice to report from a file which is overwritten every month.

      Ex-Filename:ABC.xls

       

      MonthEmployeeExpense
      Jan-10A1000
      Jan-10B2000
      Jan-10C3000
      Jan-10D4000
      Jan-10E5000
      Jan-10F6000


      We recieve Feb,2010 data with the same file name ABC.xls, with a new set of data. The number of rows is expected to be fixed, just the col expense will change month over month.

      Now I have tried partial reload option and able to generate reports but still looking out for answers to the following:

      1) Is using incremental load a better option?

      2)Is there any issues I should keep in mind for scheduling monthly reloads?