How can you be in a position to create indexes after completion of the load process?

Question

If session fails after loading 10000 records in the target, how can we load 10001 the record when we run the session in the next time?

Answer 1

For the purpose of creating indexes after the load process, command tasks at session level can be used. Index creating scripts can be brought in line with the session’s workflow or the post session implementation sequence. Moreover this type of index creation cannot be controlled after the load process at transformation level.

create Indexes after the load process is done

Using post Sql  in session.
OR
In unix we do like this...
#!/usr/bin/ksh
sqlplus -s username/password<<END
execute proc_drop_idx;
Commit;
exit;
END
============================create or replace procedure proc_drop_idx
as
begin
EXECUTE IMMEDIATE 'drop index dept_idx';
end;