Usage Note 33532: Using the replicateTransactions macro to specify which date key to use for table replication
 |  |  |  |  |
The replicateTransactions macro now has a date_key parameter that enables you to choose the date key to use for replication. The parameters and their default values for %replicateTransactions are:
%replicateTransactions(routedAlertLib=,
routedAlertTable=,
coreFactLib=,
coreFactTable=,
kcFactLib=,
kcFactTable=,
triggeringTransLib=stg_aler,
triggeringTransTable=triggeringtrans,
date_key=date_key,
bl_temp=YES,
bulkload=,
bl_tempload=
);
- routedAlertLib is the SAS® library containing the data set output from the route module.
- routedAlertTable is the output data set from the route module.
- coreFactLib is the SAS library pointing to the Core database.
- coreFactTable is the name of the fact table being replicated from the Core database.
- kcFactLib is the SAS library pointing to the Knowledge Center database.
- kcFactTable is the name of the target replication fact table in the Knowledge Center database.
- triggeringTransLib is the SAS library that contains the triggering transactions data set.
- triggeringTransTable is the SAS data set that contains the triggering transaction keys generated from scenario execution and combine_alerts.
- date_key is the name of the "date_key" column used when replicating fact tables. The default column is DATE_KEY; this value can be replaced with another date key. For example, for FSC_ACCOUNT_TRADE_FACT table the date_key parameter would be set to TRADE_DATE_KEY.
- bl_temp is an option that indicates YES or NO to using bulk loading of the temporary database tables that are loaded to improve performance. If set to YES, the default bulk load options(TRUNCATE/REPLACE) are set by the modules and the temporary database tables are bulkloaded. If set to NO, the temprorary database tables use SQL DELETEs/INSERTs to perform the activity.
- bulkload is the bulk load option specific to DB2 or Oracle. At a minimum, bulkload must be set to YES. Other loading options specific to DB2 or Oracle can be included. All options should be enclosed with %str().
- bl_tempload is the bulk load option specific to DB2 or Oracle. At a minimum, TRUNCATE must be specified for Oracle and REPLACE must be specified for DB2. Other loading options specific to DB2 or Oracle can be included. All options should be enclosed with %str().
Select the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Anti-Money Laundering | Microsoft® Windows® for x64 | 2.1.1 | 2.2.1 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 |
| Microsoft Windows 2000 Advanced Server | 2.1.1 | 2.2.1 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows 2000 Datacenter Server | 2.1.1 | 2.2.1 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows 2000 Server | 2.1.1 | 2.2.1 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows 2000 Professional | 2.1.1 | 2.2.1 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows NT Workstation | 2.1.1 | 2.2.1 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows Server 2003 Datacenter Edition | 2.1.1 | 2.2.1 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 2.1.1 | 2.2.1 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows Server 2003 Standard Edition | 2.1.1 | 2.2.1 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows XP Professional | 2.1.1 | 2.2.1 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Windows Vista | 2.1.1 | 2.2.1 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| 64-bit Enabled AIX | 2.1.1 | 2.2.1 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| 64-bit Enabled HP-UX | 2.1.1 | 2.2.1 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| 64-bit Enabled Solaris | 2.1.1 | 2.2.1 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Linux | 2.1.1 | 2.2.1 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
A fix for this issue for SAS Anti-Money Laundering 2.1 is available at:
http://www.sas.com/techsup/download/hotfix/aml21.html#033532A fix for this issue for SAS Anti-Money Laundering 2.1.1 is available at:
http://www.sas.com/techsup/download/hotfix/aml211.html#033532
The replicateTransactions macro has a new parameter that enables you to use a different date key to replicate fact tables. By default the value is DATE_KEY. But for the fact table FSC_ACCOUNT_TRADE_FACT, the key TRADE_DATE_KEY can be specified.
| Type: | Usage Note |
| Priority: |
| Date Modified: | 2008-10-13 15:25:31 |
| Date Created: | 2008-10-06 14:47:28 |