Options for improving performance of SAS Credit Scoring FoundationMart

[claudiodejesusa]

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

[a20121248]

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.

[claudiodejesusa]

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