3 Replies Latest reply on Jul 22, 2013 8:29 PM by paul.jasa

    Strategy for working across multiple data sources

    Peter Dominick

      I am looking for the best approach for work multiple datasources. I am working with extracts from text files and, unfortunately, can't get onto a relational database at this time. Each extract contains a month of customer data and the only thing that differs between the files is the date field. There could be up to 13 datasources. How would you recommend I set things up so that I can do timeseries analyses across the datasources? Is it even practical? Am I joining? Do I have to join on every field (never joined before). Am I blending? Can I have all my calculated fields in a single place or do they have to be recreated within each data source? Etc

       

      Any thoughts would be appreciated.

       

      thx

      Peter