Vizag Legend2(Pre_ODS_CDR)

[srini84]

SESSIONS 5;
RECORD 1 THRU 100;
TENACITY 5;
SLEEP 5;
ERRLIMIT 50;
.logon tdp6/POC_ETLUSER,POC_ETLUSER;
delete from POC_WORKDB.STG_Prepaid_ODS_Voice_Detail all;
DROP TABLE POC_WORKDB.STG_Prepaid_ODS_Voice_Detail_WT;
DROP TABLE POC_WORKDB.STG_Prepaid_ODS_Voice_Detail_ET;
DROP TABLE POC_WORKDB.STG_Prepaid_ODS_Voice_Detail_UV;

.SET RECORD VARTEXT "|";

DEFINE

CALL_START_TIME (VARCHAR (19)),
CALL_END_TIME (VARCHAR (19) ),
A_NUMBER (VARCHAR (22)),
B_NUMBER (VARCHAR (22)),
IMEI_NUMBER (VARCHAR (15)),
IMSI_NUMBER (VARCHAR (15)),
PEAK_INDICATOR (VARCHAR (3)),
CALL_DURATION (VARCHAR (10)),
RATED_REVENUE (VARCHAR (10)),
NETWORK_USAGE (VARCHAR (8)),
B_PREFIX (VARCHAR (20)),
GROUP_USAGE (VARCHAR (45)),
CALL_TARIFF (VARCHAR (30)),
RATE_PLAN (VARCHAR (10)),
REGION (VARCHAR (10)),
PRODUCT (VARCHAR (20),
BRAND (VARCHAR (20)),
CUSTOMER_SEGMENT (VARCHAR (20)),
PACKAGE_TYPE (VARCHAR (90)),
CALL_BLOCKS (VARCHAR (10)),
CHARGED_DURATION (VARCHAR (10)),
CALL_TYPE (VARCHAR (5)),
CALL_REGION (VARCHAR (10)),
LAC_ID (VARCHAR (20)),
CELL_ID (VARCHAR (20)),
SUB_STATE (VARCHAR (100)),
VATP_NAME (VARCHAR (20)),
CELL_STATE (VARCHAR (50)),
CELL_REGION (VARCHAR (80))


FILE= / root /storage;

SHOW;
BEGIN LOADING POC_WORKDB.STG_Prepaid_ODS_Voice_Detail ERRORFILES
POC_WORKDB.STG_Prepaid_ODS_Voice_Detail_ET,POC_WORKDB.STG_Prepaid_ODS_Voice_Detail_UV
CHECKPOINT 1000;
INSERT INTO POC_WORKDB.STG_Prepaid_ODS_Voice_Detail VALUES(
:CALL_START_TIME,
:CALL_END_TIME,
:A_NUMBER,
:B_NUMBER,
:IMEI_NUMBER,
:IMSI_NUMBER,
EAK_INDICATOR,
:CALL_DURATION,
:RATED_REVENUE,
:NETWORK_USAGE,
:B_PREFIX,
:GROUP_USAGE,
:CALL_TARIFF,
:RATE_PLAN,
:REGION,
RODUCT,
:BRAND,
:CUSTOMER_SEGMENT,
ACKAGE_TYPE,
:CALL_BLOCKS,
:CHARGED_DURATION,
:CALL_TYPE,
:CALL_REGION,
:LAC_ID,
:CELL_ID,
:SUB_STATE,
:VATP_NAME,
:CELL_STATE,
:CELL_REGION

);

END LOADING;
.LOGOFF;
.QUIT;