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

How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...

1083


State the difference between an operational datastage and a data warehouse?

609


What are the different type of jobs in datastage?

608


What is active and passive stage?

880


What are the types of containers?

691






What are the features of datastage flow designer?

635


AGGREGATOR default datatype

937


Can you explain how could anyone drop the index before loading the data in target in datastage?

896


What is datastage?

649


Different ways a project can be moved to production ?...example ….export-import and Version control.

1936


What could be a data source system?

579


How to read multiple files using a single datastage job if files have the same metadata?

740


What are the functionalities of link collector?

627


Why we use surrogate key?

700


what are the errors,warnings in datastage

2155