1 Reply Latest reply on Aug 9, 2017 6:24 PM by Thomas Dodds

    Trade Finance Data Model

    Sunny86

      Dear All,

       

       

      We have a difficult situation with the datamodel for trade finance.

       

      We have several modules like

       

       

      Import LC

      Export LC

      Guarantee

      Import Business Collection

      Export  BusinessCollection

       

       

      etc

       

       

      in that Import LC we have measures and dates in the table and it has a Negotiation table under that

       

      -> Import LC

             -> Import Negotiation Master(Multiple Negotiations for each LC)

                     -> Import Negotiation Detail(Multiple records for each negotiation like one for request received, request processed,document checking,payment processing etc)

       

       

      Similar situation for export LC

       

       

       

       

      Business needs reports which consist of data from all the bundles.

       

       

      How can we model this. Any help will be highly appreciated.

        • 1. Re: Trade Finance Data Model
          Thomas Dodds

          Physically join on your keys ...

           

          Logically you must reduce this to a star - you need to map out what your dimensions (attributes) and facts (measures) are.  Be prepared (especially with that Negotiation Detail table) to create additional physical structures to make this work (perform) -- if indeed it is highly snowflaked with a volume of rows, and the detail table contains multiple logical 'types' of information.