Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Vizag Legend

Status
Not open for further replies.

srini84

Technical User
Joined
Feb 19, 2011
Messages
6
Location
IN
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,
:PROVIDER_ID,
:JURISDICTION,
:RATE_CURRENCY_CODE,
:ACCOUNT_NO,
:SUBSCR_NO,
:SUBSCR_NO_RESETS,
:EXTERNAL_ID,
:EXTERNAL_ID_TYPE,
:POINT_ORIGIN,
:COUNTRY_CODE_ORIGIN,
:COUNTRY_DIAL_CODE_ORIGIN,
:POINT_ID_ORIGIN,
:POINT_TAX_CODE_ORIGIN,
:POINT_TAX_CODE_TYPE_ORIGIN,
:POINT_TARGET,
:COUNTRY_CODE_TARGET,
:POINT_ID_TARGET,
:POINT_TAX_CODE_TARGET,
:POINT_TAX_CODE_TYPE_TARGET,
:BASE_AMT,
:RATE_DT,
:TRANS_DT,
:SECOND_DT,
:TAX_RATE_ACTIVE_DT,
:TAX_RATE_INACTIVE_DT,
:AUX_TAX_INFO,
:TIMEZONE,
:PRIMARY_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,
:POINT_CLASS_ORIGIN,
:POINT_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,
:DURATION,
:NO_OF_KILOBYTES,
:INSERT_DATE,
:ACTUAL_KILOBYTES,
:JURISDICTION_ID,
:NETWORK_REF,
:NETWORK_REF_DESC,
:CELL_NETWORK
);

END LOADING;
.LOGOFF;
.QUIT;
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top