Loading files into database with incomple data -
08-20-2008
, 12:19 PM
Hi, all,
I have the following scenario:
I have one file with multiple lines, but each table's record may
contain data regarding more than one line of the file.
The key is the same, but two lines of the file may have different
parameters and they should be joined and loaded into a single record
of the database.
How should this be done? May I create a temporary table with a 1:1
mapping for file / database and then run execute another SQL statement
joining this data?
Thanks,
--
Andre |