SAS FACT TABLE

[sharon4pal]

Hello All,

I'm new to SAS and I will like to know what kind of data should be in FSC_CASH_FLOW_FACT and FSC_ACCOUNT_EVENT_FACT.

Kindly advise     

[Amir]

Hi,

It's not entirely clear from your question what the context is, so I tried a web search of "FSC_CASH_FLOW_FACT" and one of the links I found was:

https://communities.sas.com/t5/Fraud-and-Financial-Crimes/Where-can-I-find-columns-of-Fact-Dimension...

which might be of some help.

If you need something else then you might need to supply more details for others to respond to.

Regards,

Amir.

[sharon4pal]

Thank you Amir,

I was just wondering if fsc_cash_flow_fact and fsc_account_event_fact should hold the same data or if cash_flow_fact table should only contain cash transaction data and account event table should contain ALL transaction data including cash related transactions.

[Patrick]

@sharon4pal

SAS AML questions go better under "Risk and Fraud"/"Fraud and Financial Crimes" to not confuse people who don't know this SAS solution.

The tables you ask about are both from the SAS AML Core data model. The AML documentation would answer your question.

From memory: FSC_CASH_FLOW FACT is for monetary transactions, FSC_ACCOUNT_EVENT_FACT is for non-monetary transactions (i.e. an inquiry). 

[TomKari]

I'm not sure that this is a SAS question. Typically, a FACT table is a component of a data storage mechanism called a "star schema", which can be constructed using any one of a number of technologies, including SAS. Here's some documentation about them. I should warn you, it is an advanced topic for a novice / non-IT user.

https://en.wikipedia.org/wiki/Star_schema

Tom

[SASKiwi]

Have you checked the documentation? You need a user name and password to access it but I assume you have one since you have the product licensed:

http://support.sas.com/documentation/onlinedoc/securedoc/index_fraudmmgt.html

[sharon4pal]

We did not buy fraud

[Patrick]

@sharon4pal

If these are not tables from the SAS Anti-Money Laundering (AML) solution data model then one would need to know the data model to answer your question.

If these are tables from the SAS AML model then you need to operate under a valid SAS AML license as else I'd assume you'd be in breach of that license.