4 Replies Latest reply on Apr 24, 2012 8:34 AM by nicolas duminil

    A design question with files, aggregators, data bases, etc.

    nicolas duminil Master

      Greetings,

       

      I have the following case: different inter-related files come by FTP. These files are related in the sense that one may contain a record, say a Product, and another file may contain records concerning the Product movements. The relation is based on a product id. Basically, the data come from a database having a one to many relationshipm but, for some reason, it arrives as separate files, one file with the product definitions and any number of files that may contain movements of the defined products. I need to consolidate all that in a database having this one to many relationship.

       

      What would be the recommended design of that, knowing that the files may be huge and their number unknown ?

       

      Many thanks in advance,

       

      Nicolas