Home Loan Application

View previous topic View next topic Go down

Home Loan Application

Post  tim_goodsell on Thu Oct 08, 2015 11:33 pm

Hi


I am creating a dimensional model for Home Loan Applications where each home loan application that can have multiple loans associated with it and also multiple applicants

There will be lots of dates like ApplicationReceivedDate and ApplicationFirstApprovalDate plus id's like LoanID and ApplicationID as well as LoanPurpose, LoanAmount, LoanApplicationStatus as well as

Do I just create a accumulating fact table at the loan grain level which will for each loan include the application dates and status as well as the loan amount or do I need to create a loan fact table which is linked to an application dimension ?

Thanks

Tim

tim_goodsell

Posts : 49
Join date : 2010-09-21

View user profile

Back to top Go down

Home Loan Application

Post  zoom on Fri Oct 09, 2015 8:30 am

Yes, a accumulating fact table with start and end date on the fact table would work. It is called SCD type 2 Fact table. A start and end date on the fact table allow you to find out when do you get information on a specific measures and it allows you to get the latency time/day among measures. You can search Kimball Tips library to get more information on creating a start and end data on a fact table.

zoom

Posts : 97
Join date : 2010-08-23
Location : Chicago

View user profile

Back to top Go down

Re: Home Loan Application

Post  BoxesAndLines on Fri Oct 23, 2015 11:41 pm

What metrics are important to your users? Pipeline reporting is best done using accumulating snapshots. Daily snapshots are also good for other types of reporting.
avatar
BoxesAndLines

Posts : 1212
Join date : 2009-02-03
Location : USA

View user profile

Back to top Go down

Application Dimension

Post  tim_goodsell on Mon Jan 18, 2016 7:27 pm

Hi

Also a home loan application can have more than one customer how do I model that ?, a bridge table ?

Regards

Tim

tim_goodsell

Posts : 49
Join date : 2010-09-21

View user profile

Back to top Go down

Re: Home Loan Application

Post  zoom on Tue Jan 19, 2016 8:23 am

It depends on your business users need if you want to create a bridge table.... if business user wants to see all the borrowers on a report.  Usually primary borrower is used in a report. Lets assume your business user wants to see only primary and secondary borrowers on the report. In that case the other option you have is to use your customer dim as role playing dim.... have 2 foreign keys ( 1 key for primary and other key for secondary borrower)  from your customer dim to your fact table.

zoom

Posts : 97
Join date : 2010-08-23
Location : Chicago

View user profile

Back to top Go down

Re: Home Loan Application

Post  Sponsored content


Sponsored content


Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum