1 / 9

By A Sai Krishna Geethika Lokanadham Mithun Rajanna KV Kumar

Data warehousing for Risk Analysis. By A Sai Krishna Geethika Lokanadham Mithun Rajanna KV Kumar. Business Needs. A specialized OLAP system for monitoring customer credit risk information is a fundamental requirement Credit risk for a particular customer at any given point of time

bairn
Download Presentation

By A Sai Krishna Geethika Lokanadham Mithun Rajanna KV Kumar

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Data warehousingforRisk Analysis By A Sai Krishna GeethikaLokanadham MithunRajanna KV Kumar

  2. Business Needs • A specialized OLAP system for monitoring customer credit risk information is a fundamental requirement • Credit risk for a particular customer at any given point of time • Credit risk for wholesale/retail customers at any given point of time • Credit risk for any given country’s customer • Credit risk for a particular product customer

  3. Star Schema • More effective for handling simpler queries for users to write, and databases to process. • Queries are written with simple inner joins between the facts and a small number of dimensions. • Star joins are simpler than possible in snowflake schema. Where conditions need only to filter on the attributes desired, and aggregations are fast. • To optimize user ease-of-use and retrieval performance by minimizing the number of tables to join to materialize a transaction

  4. Fact Table • RISK table

  5. Dimension Table

  6. Datawarehouse Star Schema

  7. Dimension Table Data

  8. Fact Table Data

  9. Thank you

More Related