Navigation :
test ../../../../ test user-ref.html
User & Reference Guide
test ../../../../ test getting-started.html
Getting started
test ../../../../ test getting-started/using-this-guide.html
- Using this guide
test ../../../../ test getting-started/whats-new.html
- What's New
test ../../../../ test getting-started/frtb-data-model.html
- FRTB Data Model
test ../../../../ test tutorials.html
Tutorials
test ../../../../ test tutorials/data-health-check.html
- Data Health Check
test ../../../../ test tutorials/tips-for-validating-the-calculations.html
- Tips for Validating the Calculations
test ../../../../ test tutorials/viewing-qis-numbers.html
- Viewing QIS Numbers
test ../../../../ test tutorials/workaround-for-deadlock-issue-when-attempting-to-create-partitions-for-reference-stores.html
- Workaround for deadlock issue when attempting to create partitions for reference stores
test ../../../../ test configuration.html
Configuration files
test ../../../../ test sign-off.html
Sign-Off Approvals
test ../../../../ test cube.html
Data Cubes
test ../../../../ test what-if.html
What-If Analysis
test ../../../../ test datastore.html
Data Stores
test ../../../../ test input-files.html
Input Files
test ../../../../ test dev.html
Developer Guide
test ../../../../ test dev/dev-release.html
-
Release and migration notes
test ../../../../ test dev/dev-getting-started.html
-
Getting Started
test ../../../../ test dev/dev-ref-impl.html
-
FRTB Reference Implementation
test ../../../../ test dev/dev-ref-impl/dev-config-files.html
--
Configuration files
test ../../../../ test dev/dev-ref-impl/dev-input-files.html
--
Input file formats
test ../../../../ test dev/dev-ref-impl/dev-dlc.html
--
Data Load Controller in the FRTB Accelerator
test ../../../../ test dev/dev-ref-impl/dev-etl.html
--
FRTB ETL (Extract/Transform/Load)
test ../../../../ test dev/dev-ref-impl/dev-etl/etl-ima.html
---
ETL for IMA Overview
test ../../../../ test dev/dev-ref-impl/dev-etl/etl-sa.html
---
ETL for SA Overview
test ../../../../ test dev/dev-ref-impl/dev-etl/etl-sa/sa-etl-for-drc.html
---- SA ETL for DRC
test ../../../../ test dev/dev-ref-impl/dev-etl/etl-sa/sa-etl-for-other-files.html
---- SA ETL for Other Files
test ../../../../ test dev/dev-ref-impl/dev-etl/etl-sa/sa-etl-for-sbm-curvature.html
---- SA ETL for SBM Curvature
test ../../../../ test dev/dev-ref-impl/dev-etl/etl-sa/sa-etl-for-sbm-delta.html
---- SA ETL for SBM Delta
test ../../../../ test dev/dev-ref-impl/dev-etl/etl-sa/sa-etl-for-sbm-vega.html
---- SA ETL for SBM Vega
test ../../../../ test dev/dev-ref-impl/dev-etl/etl-sa/sa-etl-for-trade-attributes.html
---- SA ETL for Trade Attributes
test ../../../../ test dev/dev-ref-impl/dev-rest.html
--
REST Services
test ../../../../ test dev/dev-ref-impl/dev-datastore.html
--
FRTB Datastore Configuration
test ../../../../ test dev/dev-ref-impl/cube-config-intro.html
-- FRTB Cube Configuration
test ../../../../ test dev/dev-ref-impl/dev-measures-context.html
-- Measures and context values
test ../../../../ test dev/dev-ref-impl/sign-off-analysis-hierarchy.html
-- Sign-Off Analysis Hierarchy
test ../../../../ test dev/dev-core.html
-
FRTB Core
test ../../../../ test dev/dev-extensions.html
-
Extending the Accelerator
test ../../../../ test dev/dev-tools.html
-
Configuring Accelerator tools and methodologies
test ../../../../ test dev/dev-sign-off.html
-
Sign-Off
test ../../../../ test interpret-impl.html
FRTB Accelerator Interpretation and Implementation of BCBS 457
test ../../../../ test pdf-guides.html
PDF Guides
test ../../../../ test glossary.html
Glossary
SA ETL for Other Files
This page provides an overview of ETL for other SA files (i.e. those not
categorised under delta, vega, curvature, DRC, or trade attributes),
starting with a dataflow diagram for Other CSV files.
Dataflow Diagram
Other SA Files
![sa ETL dataflow diagram for other fiels](/images/etl/38708348.png
Vectorisation and Interpolation
No vectorisation or interpolation is performed on any of the files
covered in this topic.
Normalization
All fields in the relevant stores are filled directly from the fields in
the files. No specific tuple publishing is used. The AsOfDate field can
be filled in via a Column Calculator, if it does not exist in the file.
This applies to all relevant stores.
Relevant Stores
The stores that are relevant for the files covered in this topic are:
Stores
CommodityBuckets
CommodityBucketsRiskWeights
CommodityIntraBucketCorrelations
EquityBuckets
EquityBucketsRiskWeight
CSRBucketDesc
CSRNonSecBucket
CSRSecCTPBucket
CSRSecNonCTPBucket
CSRBucketsRiskWeight
CSRBucketCorrelations