LOAD DATA INFILE "/var/opt/ascential/data/jj/CDRNOK_MSCHEMCHU1_20051106010701_2547.dat.bman.1219332" APPEND INTO TABLE CDR_TMPJJ FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS ( EDW_CDR_ID SEQUENCE(1219332000000000,1), VENDOR DECIMAL EXTERNAL, SEQUENCE_NUMBER DECIMAL EXTERNAL, RECORD_TYPE DECIMAL EXTERNAL, CALL_ID_NUMBER CHAR, RELATED_CALL_NUMBER CHAR, NETWORKCALL_REFERENCE CHAR, PARTIAL_OUTPUT DECIMAL EXTERNAL, PARTIAL_OUTPUT_RECNUM DECIMAL EXTERNAL, EXCHANGE_IDENTITY CHAR, TYPE_OF_CALLING_SUBSCRIBER FILLER DECIMAL EXTERNAL, TYPE_OF_CALLED_SUBSCRIBER FILLER DECIMAL EXTERNAL, CALLING_IMSI DECIMAL EXTERNAL, CALLING_IMEI DECIMAL EXTERNAL, CALLING_COUNTRYCODE DECIMAL EXTERNAL, CALLING_ISDN DECIMAL EXTERNAL, CALLING_PARTY_NUMBER CHAR, CALLED_IMSI DECIMAL EXTERNAL, REDIRECTING_IMSI DECIMAL EXTERNAL, CALLED_IMEI DECIMAL EXTERNAL, CALLED_COUNTRYCODE DECIMAL EXTERNAL, CALLED_ISDN DECIMAL EXTERNAL, CALLED_PARTY_NUMBER CHAR, MSROAM_NUMBER_COUNTRYCODE DECIMAL EXTERNAL, MSROAM_NUMBER_ISDN DECIMAL EXTERNAL, MSROAM_NUMBER CHAR, ORIGINAL_CALLED_COUNTRYCODE DECIMAL EXTERNAL, ORIGINAL_CALLED_ISDN DECIMAL EXTERNAL, ORIGINAL_CALLED_NUMBER CHAR, SPARE1 FILLER CHAR, SPARE2 FILLER CHAR, SPARE3 FILLER CHAR, REDIRECTING_NO_COUNTRYCODE DECIMAL EXTERNAL, REDIRECTING_NO_ISDN DECIMAL EXTERNAL, REDIRECTING_NO CHAR, TIME_FOR_START_OF_CHARGE DATE 'YYYYMMDDHH24MISS', --DATE_FOR_START_OF_CHARGE EXPRESSION "TRUNC(TO_DATE(:TIME_FOR_START_OF_CHARGE,'YYYYMMDDHH24MISS'))" , TIME_FOR_STOP_OF_CHARGE DATE 'YYYYMMDDHH24MISS', CHARGEABLE_DURATION DECIMAL EXTERNAL, FIRST_LOCATION_AREA_CODE DECIMAL EXTERNAL, FIRST_CELL_ID DECIMAL EXTERNAL, FIRST_MNC DECIMAL EXTERNAL, FIRST_MCC DECIMAL EXTERNAL, LAST_LOCATION_AREA_CODE DECIMAL EXTERNAL, LAST_CELLID DECIMAL EXTERNAL, LAST_MNC DECIMAL EXTERNAL, LAST_MCC DECIMAL EXTERNAL, CAUSECODE CHAR, DISCONNECTING_PARTY DECIMAL EXTERNAL, TAC CHAR, SS_SERVICECODE CHAR, SS_REQUEST DECIMAL EXTERNAL, INCOMING_ASSIGNED_ROUTE CHAR, OUTGOING_ASSIGNED_ROUTE CHAR, INCOMING_ROUTE CHAR, OUTGOING_ROUTE CHAR, PRESENTATION_SCREENING CHAR, TRANSPARENCY_INDICATOR FILLER CHAR, SWITCH_ID CHAR, ACCEPTABLE_CHANNEL_CODINGS FILLER CHAR, ACCEPTANCE_OF_CALLWAITING FILLER CHAR, ADVICE_OF_CHARGETYPE_USED FILLER CHAR, BEARER_SERVICECODE CHAR, BSSMAP_CAUSECODE FILLER CHAR, CALLED_MS_CLASSMARK FILLER CHAR, CALLING_MS_CLASSMARK FILLER CHAR, CAMEL_CALL_REFERENCE CHAR, CAMEL_SERVICE_KEY1 CHAR, CAMEL_MSCADDRESS_COUNTRYCODE FILLER DECIMAL EXTERNAL, CAMEL_MSCADDRESS_ISDN DECIMAL EXTERNAL, CAMEL_MSCADDRESS_NUMBER FILLER CHAR, CAMEL_SWITCHID CHAR, CHANNEL_CODING_USED FILLER CHAR, CHANNEL_RATE_REQUESTED FILLER CHAR, CHARGING_PULSES FILLER CHAR, CLASSMARK3 FILLER CHAR, CUG_MEMBER FILLER CHAR, CUG_NETWORK_IDENTIFIER FILLER CHAR, CUG_OUTGOING_ACCESS_INDICATOR FILLER CHAR, DISCONNECT_DUETO_SYST_RECOVERY FILLER CHAR, DTMF_USED FILLER CHAR, EXTERNAL_CLIENT_ID FILLER CHAR, FAULTCODE CHAR, IN_CHANNEL_DATE DATE 'YYYYMMDDHH24MISS', INSTIGATON_OF_LOCATION FILLER CHAR, INVOCATION_OF_CALLHOLD CHAR, LOCATION_DECIPHER FILLER CHAR, MSGE_CENTREADDRESS_COUNTRYCODE FILLER DECIMAL EXTERNAL, MSGE_CENTREADDRESS_ISDN DECIMAL EXTERNAL, MSGE_CENTREADDRESS_NUMBER CHAR, MSGE_REFERENCE CHAR, MSGE_TYPEINDICATOR CHAR, NUM_OF_CHANNELS_REQUESTED FILLER CHAR, ORIGINATING_CELL_ID DECIMAL EXTERNAL, ORIGINATING_LAC DECIMAL EXTERNAL, ORIGINATING_MNC DECIMAL EXTERNAL, ORIGINATING_MCC DECIMAL EXTERNAL, OUTCHANNEL_TIME DATE 'YYYYMMDDHH24MISS', RECORD_SEQUENCE_NUM FILLER DECIMAL EXTERNAL, REQ_HORIZONTAL_ACCURACY FILLER CHAR, REQ_VERTICAL_ACCURACY FILLER CHAR, RESTART_DURING_CALL FILLER CHAR, SCF_ADDRESS_COUNTRYCODE FILLER DECIMAL EXTERNAL, SCF_ADDRESS_ISDN DECIMAL EXTERNAL, SCF_ADDRESS_NUMBER FILLER CHAR, SERVED_CELL_ID DECIMAL EXTERNAL, SERVED_MSCLASSMARK FILLER CHAR, SPEECH_VERSION_USED FILLER CHAR, TELESERVICE_CODE CHAR, TIME_SEIZURE_TO_START_CHARGE DECIMAL EXTERNAL, STARTTIMESPARE FILLER DATE 'YYYYMMDDHH24MISS', STOPTIMESPARE FILLER DATE 'YYYYMMDDHH24MISS', UE_POSITION FILLER CHAR, UMTS_CALL_DISCONNECT FILLER CHAR, ADD_ROUTING_CATEGORY FILLER DECIMAL EXTERNAL, ANSWER_TIME DATE 'YYYYMMDDHH24MISS', APPLICATION_INFO FILLER DECIMAL EXTERNAL, B_IDLE_TIME FILLER DATE 'YYYYMMDDHH24MISS', BASIC_CALL_STATE_MODEL FILLER DECIMAL EXTERNAL, BASIC_SERVICE_TYPE DECIMAL EXTERNAL, CALL_STATE DECIMAL EXTERNAL, CALL_TYPE DECIMAL EXTERNAL, CALLED_CELL_BAND FILLER DECIMAL EXTERNAL, CALLED_MODIFY_PARAMETERS FILLER CHAR, CALLED_MSRN_NPI FILLER DECIMAL EXTERNAL, CALLED_MSRN_TON DECIMAL EXTERNAL, CALLED_NUMBER_NPI FILLER DECIMAL EXTERNAL, CALLED_NUMBER_TON DECIMAL EXTERNAL, CALLED_SUBS_CI DECIMAL EXTERNAL, CALLED_SUBS_FIRST_MCC DECIMAL EXTERNAL, CALLED_SUBS_FIRST_MNC DECIMAL EXTERNAL, CALLED_SUBS_LAC CHAR, CALLED_SUBS_LAST_EX_ID DECIMAL EXTERNAL, CALLED_SUBS_LAST_EX_ID_TON FILLER DECIMAL EXTERNAL, CALLED_SUBS_LAST_MCC DECIMAL EXTERNAL, CALLED_SUBS_LAST_MNC DECIMAL EXTERNAL, CALLED_VMSC_NUMBER CHAR, CALLING_CELL_BAND FILLER DECIMAL EXTERNAL, CALLING_CHARGING_AREA FILLER DECIMAL EXTERNAL, CALLING_MODIFY_PARAMETERS FILLER CHAR, CALLING_NUMBER_NPI FILLER DECIMAL EXTERNAL, CALLING_NUMBER_TON DECIMAL EXTERNAL, CALLING_SUBS_FIRST_MNC DECIMAL EXTERNAL, CALLING_SUBS_LAST_EX_ID FILLER DECIMAL EXTERNAL, CALLING_SUBS_LAST_EX_ID_TON FILLER DECIMAL EXTERNAL, CALLING_SUBS_LAST_MCC DECIMAL EXTERNAL, CALLING_SUBS_LAST_MNC DECIMAL EXTERNAL, CALLING_SUBS_MCC DECIMAL EXTERNAL, CALLING_SUBS_MNC DECIMAL EXTERNAL, CALLING_VMSC_NUMBER CHAR, CAMEL_EXCHANGE_ID_TON FILLER DECIMAL EXTERNAL, CAMEL_MODIFICATION CHAR, CAMEL_MODIFY_PARAMETERS FILLER CHAR, CAUSE_FOR_TERMINATION CHAR, CAUSE_FOR_FORWARDING CHAR, CF_INFORMATION DECIMAL EXTERNAL, CHARGEABLE_DURATION2 FILLER DECIMAL EXTERNAL, CHECK_SUM FILLER DECIMAL EXTERNAL, COMMAND_TYPE FILLER CHAR, CONCATENATED_RECORD_NUMBER DECIMAL EXTERNAL, CONCATENATED_SMS_REFERENCE DECIMAL EXTERNAL, CONNECTED_TO_NUMBER CHAR, CONNECTED_TO_NUMBER_NPI FILLER DECIMAL EXTERNAL, CONNECTED_TO_NUMBER_TON FILLER DECIMAL EXTERNAL, CUG_INFORMATION FILLER DECIMAL EXTERNAL, DATA_VOLUME FILLER DECIMAL EXTERNAL, DEFAULT_CALL_HANDLING DECIMAL EXTERNAL, DELIVERY_TIME DATE 'YYYYMMDDHH24MISS', DESTINATION_NUMBER CHAR, DESTINATION_NUMBER_NPI FILLER DECIMAL EXTERNAL, DESTINATION_NUMBER_TON DECIMAL EXTERNAL, DEVICE_IDENTIFIER FILLER DECIMAL EXTERNAL, DIALLED_DIGITS CHAR, DIALLED_DIGITS_NPI FILLER DECIMAL EXTERNAL, DIALLED_DIGITS_TON DECIMAL EXTERNAL, DURATION_BEFORE_ANSWER FILLER DECIMAL EXTERNAL, DURATION_BEFORE_ANSWER_TEN_MS FILLER DECIMAL EXTERNAL, FORW_MCZ_CHANGE_DIRECTION FILLER DECIMAL EXTERNAL, FORW_MCZ_CHANGE_PERCENT FILLER DECIMAL EXTERNAL, FORW_MCZ_CHRG_TYPE FILLER CHAR, FORW_MCZ_DURATION DECIMAL EXTERNAL, FORW_MCZ_PULSES FILLER DECIMAL EXTERNAL, FORW_MCZ_TARIFF_CLASS FILLER DECIMAL EXTERNAL, FORWARDED_TO_FIRST_CI DECIMAL EXTERNAL, FORWARDED_TO_LAST_CI DECIMAL EXTERNAL, FORWARDED_TO_LAST_EX_ID_TON FILLER DECIMAL EXTERNAL, FORWARDED_TO_LAST_MCC DECIMAL EXTERNAL, FORWARDED_TO_LAST_MNC DECIMAL EXTERNAL, FORWARDED_TO_MS_CLASSMARK FILLER DECIMAL EXTERNAL, FORWARDED_TO_MSRN_NPI FILLER DECIMAL EXTERNAL, FORWARDED_TO_MSRN_TON DECIMAL EXTERNAL, FORWARDED_TO_NUMBER_NPI FILLER DECIMAL EXTERNAL, FORWARDED_TO_NUMBER_TON FILLER DECIMAL EXTERNAL, FORWARDED_TO_SMSC FILLER DECIMAL EXTERNAL, FORWARDING_CELL_BAND FILLER DECIMAL EXTERNAL, FORWARDING_IMEI DECIMAL EXTERNAL, FORWARDING_LAST_EX_ID_TON FILLER DECIMAL EXTERNAL, FORWARDING_MSRN DECIMAL EXTERNAL, FORWARDING_MSRN_NPI FILLER DECIMAL EXTERNAL, FORWARDING_MSRN_TON DECIMAL EXTERNAL, FORWARDING_NUMBER_NPI FILLER DECIMAL EXTERNAL, FORWARDING_NUMBER_TON DECIMAL EXTERNAL, HOT_BILLING_RECORD_NUMBER FILLER DECIMAL EXTERNAL, IAZ_CHRG_TYPE FILLER CHAR, IAZ_DURATION FILLER DECIMAL EXTERNAL, IAZ_PULSES FILLER DECIMAL EXTERNAL, IAZ_TARIFF_CLASS FILLER DECIMAL EXTERNAL, IN_DATA FILLER CHAR, IN_DATA_LENGTH FILLER DECIMAL EXTERNAL, IN_RECORD_NUMBER FILLER DECIMAL EXTERNAL, INTERMEDIATE_CHRG_CAUSE FILLER CHAR, LEVEL_OF_CAMEL_SERVICE FILLER DECIMAL EXTERNAL, LOC_ROUTING_NUMBER CHAR, LOC_ROUTING_NUMBER_TON FILLER DECIMAL EXTERNAL, MSC_TYPE DECIMAL EXTERNAL, NPDB_QUERY_STATUS DECIMAL EXTERNAL, NUM_OF_CONCATENATED_SMS DECIMAL EXTERNAL, NUMBER_OF_ALL_IN_RECORDS FILLER DECIMAL EXTERNAL, NUMBER_OF_FORWARDINGS DECIMAL EXTERNAL, NUMBER_OF_IN_RECORDS FILLER DECIMAL EXTERNAL, NUMBER_OF_SS_RECORDS DECIMAL EXTERNAL, OAZ_CHANGE_DIRECTION FILLER DECIMAL EXTERNAL, OAZ_CHANGE_PERCENT FILLER DECIMAL EXTERNAL, OAZ_CHRG_TYPE FILLER CHAR, OAZ_DURATION FILLER DECIMAL EXTERNAL, OAZ_DURATION_TEN_MS FILLER DECIMAL EXTERNAL, OAZ_PULSES FILLER DECIMAL EXTERNAL, OAZ_TARIFF_CLASS FILLER DECIMAL EXTERNAL, OPTIMAL_ROUTING_INDICATOR FILLER DECIMAL EXTERNAL, ORIG_CALLED_NUMBER_NPI FILLER DECIMAL EXTERNAL, ORIG_CALLED_NUMBER_TON DECIMAL EXTERNAL, ORIG_CALLING_NUMBER_NPI FILLER DECIMAL EXTERNAL, ORIG_CALLING_NUMBER_TON DECIMAL EXTERNAL, ORIG_DIALLING_CLASS FILLER DECIMAL EXTERNAL, ORIG_MCZ_CHANGE_DIRECTION FILLER DECIMAL EXTERNAL, ORIG_MCZ_CHANGE_PERCENT FILLER DECIMAL EXTERNAL, ORIG_MCZ_CHRG_TYPE FILLER CHAR, ORIG_MCZ_MODIFY_DIRECTION FILLER DECIMAL EXTERNAL, ORIG_MCZ_MODIFY_PERCENT FILLER DECIMAL EXTERNAL, ORIG_MCZ_PULSES FILLER DECIMAL EXTERNAL, ORIG_MCZ_TARIFF_CLASS FILLER DECIMAL EXTERNAL, OUTPULSED_NUMBER CHAR, OUTPULSED_NUMBER_NPI FILLER DECIMAL EXTERNAL, OUTPULSED_NUMBER_TON FILLER DECIMAL EXTERNAL, PARAMETERS CHAR, PARAMETERS_LENGTH DECIMAL EXTERNAL, PARTY_TO_CHARGE FILLER CHAR, PNI FILLER DECIMAL EXTERNAL, PROTOCOL_IDENTIFICATION FILLER DECIMAL EXTERNAL, RADIO_NETWORK_TYPE FILLER DECIMAL EXTERNAL, RECORD_LENGTH FILLER DECIMAL EXTERNAL, RECORD_NUMBER DECIMAL EXTERNAL, RECORD_STATUS DECIMAL EXTERNAL, REDIRECTED_INDICATOR FILLER DECIMAL EXTERNAL, REDIRECTING_NUMBER_NPI FILLER DECIMAL EXTERNAL, REDIRECTING_NUMBER_TON DECIMAL EXTERNAL, REGIONAL_SUBS_INDICATOR FILLER DECIMAL EXTERNAL, REGIONAL_SUBS_LOCATION_TYPE FILLER DECIMAL EXTERNAL, REQ_AIR_INTERFACE_USER_RATE FILLER CHAR, REQ_FIXED_NW_USER_RATE FILLER CHAR, REQ_OTHER_MODEM_TYPE FILLER DECIMAL EXTERNAL, REQ_USER_INITIATED_MOD_IND FILLER DECIMAL EXTERNAL, RESULT_INDICATOR FILLER DECIMAL EXTERNAL, ROAM_MCZ_CHANGE_DIRECTION FILLER DECIMAL EXTERNAL, ROAM_MCZ_CHANGE_PERCENT FILLER DECIMAL EXTERNAL, ROAM_MCZ_CHRG_TYPE FILLER CHAR, ROAM_MCZ_DURATION DECIMAL EXTERNAL, ROAM_MCZ_PULSES FILLER DECIMAL EXTERNAL, ROAM_MCZ_TARIFF_CLASS FILLER DECIMAL EXTERNAL, ROUTING_CATEGORY FILLER DECIMAL EXTERNAL, ROUTING_INFO CHAR, ROUTING_NUMBER FILLER CHAR, SCF_ADDRESS_TON FILLER DECIMAL EXTERNAL, SCP_CONNECTION DECIMAL EXTERNAL, SERVED_CELL_BAND FILLER DECIMAL EXTERNAL, SERVED_NUMBER_NPI FILLER DECIMAL EXTERNAL, SERVED_NUMBER_TON DECIMAL EXTERNAL, SERVED_SUBS_MCC DECIMAL EXTERNAL, SERVED_SUBS_MNC DECIMAL EXTERNAL, SERVICE_IDENTIFIER FILLER CHAR, SET_UP_START_TIME DATE 'YYYYMMDDHH24MISS', SMS_LENGTH DECIMAL EXTERNAL, SS_RECORD_NUMBER DECIMAL EXTERNAL, STREAM_IDENTIFIER FILLER DECIMAL EXTERNAL, TARIFF_CLASS FILLER DECIMAL EXTERNAL, TERM_MCZ_CHANGE_DIRECTION FILLER DECIMAL EXTERNAL, TERM_MCZ_CHANGE_PERCENT FILLER DECIMAL EXTERNAL, TERM_MCZ_CHRG_TYPE FILLER CHAR, TERM_MCZ_DURATION DECIMAL EXTERNAL, TERM_MCZ_MODIFY_DIRECTION FILLER DECIMAL EXTERNAL, TERM_MCZ_MODIFY_PERCENT FILLER DECIMAL EXTERNAL, TERM_MCZ_PULSES FILLER DECIMAL EXTERNAL, TERM_MCZ_TARIFF_CLASS FILLER DECIMAL EXTERNAL, TICKET_TYPE FILLER DECIMAL EXTERNAL, USED_AIR_INTERFACE_USER_RATE FILLER CHAR, USED_FIXED_NW_USER_RATE FILLER CHAR, USED_NUMBER_OF_CHANNELS FILLER DECIMAL EXTERNAL, USED_OTHER_MODEM_TYPE FILLER DECIMAL EXTERNAL, SOURCE_SYSTEM_ID CONSTANT 016, SOURCE_CREATION_DATE CONSTANT '06-NOV-2005', EDW_LOOKUP_DATE CONSTANT '06-NOV-2005', EDW_CREATE_PROCESS_ID CONSTANT 1219332, EDW_DELTA_LOAD_ID CONSTANT 911)