My client is going to provide me with an Excel spreadsheet that will be saved as a .CSV file. I am planning to us SQLLoader to load the data into a table. Here is my situation, the data has a date range, but I would like to load one row for each date in the date range.
The spreadsheet will look like this
State From date To date
01 01-JAN-2010 055-JAN-2010
I would like to load,
I know that I can load the data as it is, and then create the table I need, but I would like to know if I can bypass using an interment table.
(This is the select that I would use to create my final table if I can not have SQLLoader create the table.)
select state, period_begin_date
where period_begin_date between from_date and to_date
and hierarchy_code = '--'
*tines_dimension table has date ranges for daily weekly monthly, quarterly and yearly in multiple formats.
Has anyone done something like this? Any suggestions?