Vizag Legend

[srini84]

SESSIONS 5;
RECORD 1 THRU 100;
TENACITY 5;
SLEEP 5;
ERRLIMIT 50;
.logon tdp6/POC_ETLUSER,POC_ETLUSER;
delete from POC_WORKDB.STG_Postpaid_ODS_CDR all;
DROP TABLE POC_WORKDB.STG_Postpaid_ODS_CDR_WT;
DROP TABLE POC_WORKDB.STG_Postpaid_ODS_CDR_ET;
DROP TABLE POC_WORKDB.STG_Postpaid_ODS_CDR_UV;

.SET RECORD VARTEXT "|";

DEFINE

CDR_DATA_PARTITION_KEY (VARCHAR (40)),
MSG_ID (NUMBER (10)),
MSG_ID2 (NUMBER (3)),
MSG_ID_SERV (NUMBER (3)),
SPLIT_ROW_NUM (NUMBER (3)),
EXT_TRACKING_ID (VARCHAR2 (96)),
TRANS_ID (VARCHAR2 (20)),
ELEMENT_ID (NUMBER (10)),
TYPE_ID_USG (NUMBER (10)),
RATE_CLASS (NUMBER (6)),
BILL_CLASS (NUMBER (6)),
PROVIDER_ID (NUMBER (10)),
JURISDICTION (VARCHAR2 (240)),
RATE_CURRENCY_CODE (NUMBER (6)),
ACCOUNT_NO (NUMBER (10)),
SUBSCR_NO (NUMBER (10)),
SUBSCR_NO_RESETS (NUMBER (6)),
EXTERNAL_ID (VARCHAR2 (144)),
EXTERNAL_ID_TYPE (NUMBER (6)),
POINT_ORIGIN (VARCHAR2 (72)),
COUNTRY_CODE_ORIGIN (NUMBER (6)),
COUNTRY_DIAL_CODE_ORIGIN (VARCHAR2 (6)),
POINT_ID_ORIGIN (NUMBER (10)),
POINT_TAX_CODE_ORIGIN (VARCHAR2 (15)),
POINT_TAX_CODE_TYPE_ORIGIN (NUMBER (3)),
POINT_TARGET (VARCHAR2 (72)),
COUNTRY_CODE_TARGET (NUMBER (6)),
POINT_ID_TARGET (NUMBER (10)),
POINT_TAX_CODE_TARGET (VARCHAR2 (15)),
POINT_TAX_CODE_TYPE_TARGET (NUMBER (3)),
BASE_AMT (NUMBER (18))
RATE_DT (DATE),
TRANS_DT (DATE),
SECOND_DT (DATE),
TAX_RATE_ACTIVE_DT (DATE),
TAX_RATE_INACTIVE_DT (DATE),
AUX_TAX_INFO (VARCHAR2 (15)),
TIMEZONE (NUMBER (3)),
PRIMARY_UNITS (NUMBER (10)),
SECOND_UNITS (NUMBER (10)),
THIRD_UNITS (NUMBER (10)),
UNITS_CURRENCY_CODE (NUMBER (6)),
BILLING_UNITS_TYPE (NUMBER (6)),
CCARD_ID (NUMBER (10)),
CCARD_ID_SERV (NUMBER (3)),
ANNOTATION (VARCHAR2 (255)),
CUSTOMER_TAG (VARCHAR2 (240)),
RATED_UNITS (NUMBER (10)),
AMOUNT (NUMBER (18)),
FOREIGN_AMOUNT (NUMBER (18)),
RATE_PERIOD (VARCHAR2 (240)),
NO_BILL (NUMBER (1)),
COMP_STATUS (NUMBER (3)),
CDR_STATUS (NUMBER (3)),
FILE_ID (NUMBER (10)),
FILE_ID_SERV (NUMBER (3)),
REV_RCV_COST_CTR (NUMBER (6)),
ARCH_FLAG (NUMBER (1)),
UNROUNDED_AMOUNT (NUMBER (18)),
CORRIDOR_PLAN_ID (NUMBER (10)),
CELL_ID_ORIGIN (NUMBER (6)),
ORIG_TYPE_ID_USG (NUMBER (10)),
ACCESS_REGION_ORIGIN (VARCHAR2 (15)),
ACCESS_REGION_TARGET (VARCHAR2 (15)),
OPEN_ITEM_ID (NUMBER (10)),
NUM_RECORDS (NUMBER (10)),
AMOUNT_REDUCTION (NUMBER (18)),
AMOUNT_REDUCTION_ID (NUMBER (10)),
SEQNUM_RATE_USAGE (NUMBER (10)),
SEQNUM_RATE_USAGE_OVERRIDES (NUMBER (10)),
RAW_UNITS (NUMBER (10)),
RAW_UNITS_ROUNDED (NUMBER (10)),
AGGR_USAGE_ID (NUMBER (10)),
ZONE_CLASS (NUMBER (3)),
POINT_CLASS_ORIGIN (NUMBER (10)),
POINT_CLASS_TARGET (NUMBER (10)),
EQUIP_CLASS_CODE (NUMBER (6)),
COMPONENT_ID (NUMBER (10)),
TAX_PKG_COUNT (NUMBER (10)),
GEOCODE (CHAR (15)),
ADD_IMPLIED_DECIMAL (NUMBER (6)),
RERATED_DT (DATE),
ELEMENT_ID_DESCRIPTION (VARCHAR2 (240)),
TYPE_ID_USAGE_DESCRIPTION (VARCHAR2 (240)),
JURISDICTION_DERIVED (VARCHAR2 (240)),
CELL_ID_DESCRIPTION (VARCHAR2 (240)),
SERVICE (VARCHAR2 (240)),
RECORD_TYPE (VARCHAR2 (240)),
USAGE_GROUP (VARCHAR2 (240)),
CALL_DISPERSION (VARCHAR2 (240)),
TARIFF_TYPE (VARCHAR2 (240)),
TARIFF (VARCHAR2 (240)),
MO_MT (VARCHAR2 (25)),
OPERATOR (VARCHAR2 (240)),
B_NUMBER (VARCHAR2 (240)),
DURATION (NUMBER (18)),
NO_OF_KILOBYTES (NUMBER (18)),
INSERT_DATE (DATE),
ACTUAL_KILOBYTES (NUMBER (22,4)),
JURISDICTION_ID (NUMBER (10)),
NETWORK_REF (VARCHAR2 (50)),
NETWORK_REF_DESC (VARCHAR2 (240)),
CELL_NETWORK (VARCHAR2 (10))

FILE= / root /storage;

SHOW;
BEGIN LOADING POC_WORKDB.STG_Postpaid_ODS_CDR ERRORFILES
POC_WORKDB.STG_Postpaid_ODS_CDR_ET,POC_WORKDB.STG_Postpaid_ODS_CDR_UV
CHECKPOINT 1000;
INSERT INTO POC_WORKDB.STG_Postpaid_ODS_CDR VALUES(
:CDR_DATA_PARTITION_KEY,
:MSG_ID,
:MSG_ID2,
:MSG_ID_SERV,
:SPLIT_ROW_NUM,
:EXT_TRACKING_ID,
:TRANS_ID,
:ELEMENT_ID,
:TYPE_ID_USG,
:RATE_CLASS,
:BILL_CLASS,
ROVIDER_ID,
:JURISDICTION,
:RATE_CURRENCY_CODE,
:ACCOUNT_NO,
:SUBSCR_NO,
:SUBSCR_NO_RESETS,
:EXTERNAL_ID,
:EXTERNAL_ID_TYPE,
OINT_ORIGIN,
:COUNTRY_CODE_ORIGIN,
:COUNTRY_DIAL_CODE_ORIGIN,
OINT_ID_ORIGIN,
OINT_TAX_CODE_ORIGIN,
OINT_TAX_CODE_TYPE_ORIGIN,
OINT_TARGET,
:COUNTRY_CODE_TARGET,
OINT_ID_TARGET,
OINT_TAX_CODE_TARGET,
OINT_TAX_CODE_TYPE_TARGET,
:BASE_AMT,
:RATE_DT,
:TRANS_DT,
:SECOND_DT,
:TAX_RATE_ACTIVE_DT,
:TAX_RATE_INACTIVE_DT,
:AUX_TAX_INFO,
:TIMEZONE,
RIMARY_UNITS,
:SECOND_UNITS,
:THIRD_UNITS,
:UNITS_CURRENCY_CODE,
:BILLING_UNITS_TYPE,
:CCARD_ID,
:CCARD_ID_SERV,
:ANNOTATION,
:CUSTOMER_TAG,
:RATED_UNITS,
:AMOUNT,
:FOREIGN_AMOUNT,
:RATE_PERIOD,
:NO_BILL,
:COMP_STATUS,
:CDR_STATUS,
:FILE_ID,
:FILE_ID_SERV,
:REV_RCV_COST_CTR,
:ARCH_FLAG,
:UNROUNDED_AMOUNT,
:CORRIDOR_PLAN_ID,
:CELL_ID_ORIGIN,
:ORIG_TYPE_ID_USG,
:ACCESS_REGION_ORIGIN,
:ACCESS_REGION_TARGET,
:OPEN_ITEM_ID,
:NUM_RECORDS,
:AMOUNT_REDUCTION,
:AMOUNT_REDUCTION_ID,
:SEQNUM_RATE_USAGE,
:SEQNUM_RATE_USAGE_OVERRIDES,
:RAW_UNITS,
:RAW_UNITS_ROUNDED,
:AGGR_USAGE_ID,
:ZONE_CLASS,
OINT_CLASS_ORIGIN,
OINT_CLASS_TARGET,
:EQUIP_CLASS_CODE,
:COMPONENT_ID,
:TAX_PKG_COUNT,
:GEOCODE,
:ADD_IMPLIED_DECIMAL,
:RERATED_DT,
:ELEMENT_ID_DESCRIPTION,
:TYPE_ID_USAGE_DESCRIPTION,
:JURISDICTION_DERIVED,
:CELL_ID_DESCRIPTION,
:SERVICE,
:RECORD_TYPE,
:USAGE_GROUP,
:CALL_DISPERSION,
:TARIFF_TYPE,
:TARIFF,
:MO_MT,
:OPERATOR,
:B_NUMBER,
URATION,
:NO_OF_KILOBYTES,
:INSERT_DATE,
:ACTUAL_KILOBYTES,
:JURISDICTION_ID,
:NETWORK_REF,
:NETWORK_REF_DESC,
:CELL_NETWORK
);

END LOADING;
.LOGOFF;
.QUIT;