topic Re: SAS AML ETL Datamodel in Fraud, AML and Security Intelligence

SAS AML ETL Datamodel

ckpotab — Mon, 12 Oct 2015 18:19:18 GMT

Hello all,

I am currently trying to understand the SAS AML ETL Data models. Could someone help me with some pointers on where can I find details of the tables that are effected by running ETLs from Staging to Core.

Ex. If I run Account ETL, I would like to know what all tables in stage, core, details of the intermediate and underlying tables that are impacted by the execution of that ETL.

Your inputs are highly appreciated. Thanks in advance.

Chaitanya.

Re: SAS AML ETL Datamodel

SASKiwi — Mon, 12 Oct 2015 18:38:58 GMT

Have you looked through the SAS AML documentation? It's my understanding that you need a special login to look at the SAS documentation for this product because of its sensitive nature.

Re: SAS AML ETL Datamodel

Patrick — Mon, 12 Oct 2015 22:57:48 GMT

The ETL's from Staging to Core are always site specific. They don't come OOTB and you won't find them in the AML documentation.

You will need to get your hands on the documentation created at your site.

If implemented properly via SAS DIS: There is impact analysis, some reporting and you can also look into the jobs to graphically see which tables get used.

In the AML project I'm currently in Core is implemented in Oracle and gets loaded via a non SAS ETL tool.

Re: SAS AML ETL Datamodel

imranaltaf — Thu, 31 Dec 2015 06:24:11 GMT

It extract data from staging to AMLCORE schema. usually have same table names as in staging schema.

Re: SAS AML ETL Datamodel

proc_da — Sun, 19 Nov 2017 06:17:28 GMT

The source to staging transition will be of simple select and simple functions like cast, and case when statements using joins to join the two or more source table and inserting into the staging table.

Its better to ask the ETL Team to share the scripts for better understanding.