Discussion Locked

Case study

0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

i have to migrate data from sql server to oracle using sqlldr. my problem is that when performing this operation i have to check for validity.
eg. i have a table emp(empno pk,salesfig). if data is available it has to be updated based on the empno, else new record has to be inserted.
how do i do this?

1 reply

by g.albera

Hi,
we experienced your issue and we ended up creating this framework, that offer speed and flexibility:

--load data with sql loader into a temporary table: this ensure maximum load speed
--run a batch that work on temporary data performing allnecessary controls and check: this again offers maximum performance
--if everything went ok, truncate the temporary table (don't delete data: truncate is much more faster).

Regards,
Ing. Gianluca Albera

This discussion is closed to new replies.