I am running a job with 1000 records.. If the job gots
aborted after loading 400 records into target... In this
case i want to load the records in the target with 401
record... How will we do it??? This scenario is not for
sequence job it's only in the job Ex: Seq file--> Trans-->
Dataset..

Answer Posted / phani kumar

With the help of available Environment variable as
APT_CHECKPOINT_DIR, we can run the job for remaining records.

This is available in Datastage Administrator like.....


With Datastage Administrator - project-wide defaults for
general environment variables, set per project in the
Projects tab under Properties -> General Tab -> Environment
variables.

Here, we can enable the this checkpoint variable. Then, we
can load the remaining records........

Is This Answer Correct ?    6 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between hashfile and sequential file?

939


how to add a new records into source?

1735


What are the components of ascential data stage?

880


What are stage variables, derivations and constants?

914


Where the datastage stored his repository?

795


how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara

589


Difference between data warehousing and olap?

829


Define Data Stage?

847


What is merge stage?

976


How do you start developing a datastage project?

855


What are the different plug-ins stages used in your projects?

836


What is the purpose of interprocessor stage in server jobs?

1957


Name the different sorting methods in datastage.

812


Define data aggregation?

880


What is the importance of the exception activity in datastage?

857