Notes

#############################
# directories
#############################
#ChangeFollowingLine
export WORK_DIR="/home/dera.service/mbis"

export DATA_DIR="/feeds/mbis"
export LOG_DIR="${WORK_DIR}/log"
export CONFIG_DIR="${WORK_DIR}/config"
export SQL_DIR="${WORK_DIR}/sql"

#############################
# application
#############################
#ChangeFollowingLine
export ENV="dev"

#ChangeOnlyWithMetadataChange
export APP_NAME="MBIS"

#ChangeFollowingLine
export APP_EMAIL_ENABLED="Y"

#ChangeFollowingLine
export APP_EMAIL="[email protected]"

#############################
# Data
#############################
####### Define how many files in the dataset, can be get from metadata DB later.
## Dataset #1 is quote daily
## Dataset #2 is peer_index daily
## Dataset #3 is curve daily
## Dataset #4 is curve hourly
#ChangeOnlyWithMetadataChange
export FILE_IN_SET1=1
#ChangeOnlyWithMetadataChange
export FILE_IN_SET2=1
#ChangeOnlyWithMetadataChange
export FILE_IN_SET3=5
#ChangeOnlyWithMetadataChange
export FILE_IN_SET4=5

#DoubleCheckFollowingLine
#This is the start date of historical data in YYYYMMDD format.
export QUOTES_STARTDATE=20120601

#DoubleCheckFollowingLine
#This is the start date of historical data in YYYYMMDD format.
export PEER_INDEX_STARTDATE=20180108

#DoubleCheckFollowingLine
#This is the start date of historical data in YYYYMMDD format.
export CURVE_STARTDATE=20170816

#DoubleCheckFollowingLine
export RELOAD=FALSE

#ChangeOnlyWithMetadataChange
export QUOTES_DATASET="MBIS_QUOTE_DAILY"
#ChangeOnlyWithMetadataChange
export PEER_INDEX_DATASET="MBIS_PEER_INDEX_DAILY"
#ChangeOnlyWithMetadataChange
export CURVE_DAILY_DATASET="MBIS_CURVE_DAILY"
#ChangeOnlyWithMetadataChange
export CURVE_HOURLY_DATASET="MBIS_CURVE_HOURLY"

#export HOLIDAY_SCHEDULE="NYSE"

#############################
# Netezza
#############################
#ChangeFollowingLine, should use DERA_ETL_USER
export NZ_COMMON_CONNECTION="-host sp-sec-devnetezza.ad.sec.gov -db deradi -schema MBIS -u DERA_ETL_USR"

#DoubleCheckFollowingLine
export DB_OWNER="MBIS_OWNER"

#export ETL_USER="DERA_ETL_USER"

#############################
# Metadata (Oracle)
#############################
#ChangeFollowingLine, should use DERA_ETL_USER
export ORA_METADATA_CONNECTION="METADATA_OWNER/changeme-password@devrf1"

#DoubleCheckFollowingLine
export METADATA_USER="METADATA_OWNER"