Case study

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?