Forum Discussion
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
- erikajain02Resolver I
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.
- AnonymousNot 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
- erikajain02Resolver I
Yes...You can also Hide them in Report View to avoid confusion.