Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Data model techniques

Dear all,

 

I have the following 4 transaction tables 

 

 

              Billing              Collection        Overdue           Bounce         

               Loankey,           Loankey,            Loankey,            Loankey,

               Loanno,            Loanno,             Loanno,              Loanno,

               branch,             branch,              branch,               branch,

               Monthyr           Monthyr            Monthyr              Monthyr

 

Two master tables

 

BranchMaster       

Branch                     

 

LoanMaster

Loankey,

Loanno,

branch,

Monthyr,

customername,

Disbursementamount,

EMI amount,

Approvedby

 

and one calendar table 

Calendar

Monthyr

 

what kind of datamodel technique i have to use?

 

Regards,

Joshua.

  • Concatenate all Transational tables as 1 Table with a flag in each to identify them.

    Then Link it with master Table and Calender table for association.

9 Replies

  • Concatenate all Transational tables as 1 Table with a flag in each to identify them.

    Then Link it with master Table and Calender table for association.

    • Anonymous's avatar
      Anonymous
      Not applicable

      Dear Erika,

       

      I have appended the transanction tables into one still the tables are visible in datamodel.Is it Ok?

       

      Please see the screenshot

       

      • erikajain02's avatar
        erikajain02
        Resolver I

        Yes...You can also Hide them in Report View to avoid confusion.