Data model techniques

[Anonymous]

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.

[erikajain02 · Accepted solution]

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]

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]

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

[Anonymous]

Dear Erika ,

I have appended 4 transaction tables but data is loaded only for 1st table.Flag is available only for first table.

[erikajain02]

This sould not be the case.

Can you share your file with us or dummy data ?

[Anonymous]

Please send me ur email id.I will share the file.

[erikajain02]

erikajain02@gmail.com

[Anonymous]

Dear Erika,

I have sent the sample.

I have created a link table with the fields (AccountNo,Amount,MonthYr,Flag,Key)from the tables Register,Billing,Bounce,Overdue,Collection .And then I have connected the link table with Register , Billing,Bounce,Overdue,Collection with Key and Link table to the calendar with MonthYr.

[Anonymous]

Dear Erika,

While appending the same column names repeating. Here the column Amount repeats again.