Position (1:10) CALL_DATE
Position (11:18) CALL TIME
Position (19:41) ACCOUNT_ID
I need to load the date & time because calculation need to be done between times (i.e. calculated duration between calls, etc).
How would I create the Table schema. Would the Date be combine with Call Date & Time???
Can anyone help!!!!
11-02-2000, 10:02 AM
If you had the file in you control file, it could be something like this. I haven't tested this, but it should give you an idea of what to do.
INTO TABLE your_table
(call_date POSITION (1:18) "TO_DATE(:call_date, 'YYYY/MM/DDHH.MI.SS')",
account_id POSITION(19:41) )