Mathematical Functions in Teradata:
The following table illustrates the year-on-year transactions of a Loan account. A loan account has the Collateral and the Amount to be paid columns.
If you notice, the area where the Blue indicator(Asset with Bank) goes below the Green Indicator(Amount to be paid/Risk Exposure), is the Risk-Zone.
If the Customer defaults in this zone, the Bank will have lower assets to recover the loan. This is a classical example of Risk-Management.
All such risks are covered by the BASEL-2 norms.
How Teradata Helps?
Functions in Teradata like SUM and CSUM will help us to effectively calculate the value in the FACTS.
We can decide on these metrics, and then populate the RATE column in the dimension from Real-time Systems.
During FACT populations, the following steps can be performed:
1. the Current Value of Collateral is calculated
2. The Amount repaid is calculated
3. They are projected over a period.
A Flag can be set in the Report file/Aggregates marking the Customer account as Risky
Your queries/suggestions are always welcome !!
The following table illustrates the year-on-year transactions of a Loan account. A loan account has the Collateral and the Amount to be paid columns.
If you notice, the area where the Blue indicator(Asset with Bank) goes below the Green Indicator(Amount to be paid/Risk Exposure), is the Risk-Zone.
If the Customer defaults in this zone, the Bank will have lower assets to recover the loan. This is a classical example of Risk-Management.
All such risks are covered by the BASEL-2 norms.
How Teradata Helps?
Functions in Teradata like SUM and CSUM will help us to effectively calculate the value in the FACTS.
We can decide on these metrics, and then populate the RATE column in the dimension from Real-time Systems.
During FACT populations, the following steps can be performed:
1. the Current Value of Collateral is calculated
2. The Amount repaid is calculated
3. They are projected over a period.
A Flag can be set in the Report file/Aggregates marking the Customer account as Risky
Example: If the State-run Banks had implemented this strategy, then the defaulting of Kingfisher Airlines could be predicted. A total of INR 50 billion was borrowed by the airline, but the collateral tracking could have saved the day for the Lenders.
Your queries/suggestions are always welcome !!
No comments:
Post a Comment
Please share your thoughts and let us know the topics you want covered