Web Development

General discussion


Case study

By anandvp ·
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?

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

Case study

by g.albera In reply to Case study

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).

Ing. Gianluca Albera

Related Discussions

Related Forums