Loading from failure record

[ramakrishna56]

All,

I have Got a reqrmnt that to start the loading records from failure point in a job,which loads the records in a target oracle table.

For ex: I am loading 4000 records into target ORACLE table ,and If the job aborts after loading 3000records,the next run should start from 3001 th record.Instead of deleting already loaded 3000 records.

How can I achieve this functionality in PX?

Tx for the help in advance...

[Sainath.Srinivasan]

You can achieve this in several ways, but all depends on how the load works.

If you current load is direct into target, you can do this. But if it computes on the fly, you may have to work around that.

If you can identify the last successful rows, you can add a 'id > targetID' in your source where clause.

Alternatively you can add a constraint in any of the stages in the job.

But DS as such gives you job level checkpoints and not data level.

[ray.wurlod]

I have Got a reqrmnt that ...

For ex: ...

Tx for the help in advance...

Welcome aboard. Please invest in more vowels.

We try to maintain a professional standard of written English on DSXchange, because there are many whose first language is not English. Even correct English, I'm sure you will agree, is difficult enough. Arbitrary inventions and abbreviations only make the task more difficult.