topic Re: Options for improving performance of SAS Credit Scoring FoundationMart in SAS Risk Management

Options for improving performance of SAS Credit Scoring FoundationMart

claudiodejesusa — Fri, 12 Aug 2022 04:19:55 GMT

Hi everybody,

I'm new in this site. I want to introduce my case, my job has implemented SAS CS 6.3 in Linux RHEL 7.

We want to choose the best option for good performance and scalable FoundationMart which is the heart of the solution. We have these options in the company:
- database in SAS (filesystem)
- Oracle database

Actually, we work tables over 5-10 millions of rows and about 1000-1500 features as mastertable for analytics about credit scoring cases. Also, we merge about 10-20 tables to get that.

I would like to read about your recommendations!

Thanks,
Claudio

Re: Options for improving performance of SAS Credit Scoring FoundationMart

a20121248 — Sat, 13 Aug 2022 23:14:15 GMT

In my case we have the FM on SAS but I'm not sure if it is the best options for your case (millions of records and variables per month, it's very large).

I think @sanchit013 could give you a better recommendation. He has always provided invaluable help with Credit Scoring in the forum.

Re: Options for improving performance of SAS Credit Scoring FoundationMart

claudiodejesusa — Wed, 17 Aug 2022 12:45:16 GMT

Hi,

Thanks, i hope a sas credit scoring specialist could help me. My running is work with huge tables (about 3000k variables and 10-20 millions rows) and about 10-20 tables to joins.

I think if i use the sas engine only, it could be really hard about time processing and maintaince of tables.

thanks,
Claudio