Interested to Buy Any Domain ? << Click Here >> for more details...
how can i abort the job if i get more than 100 errors in
job log?
- 6 Answers
- 24650 Views
- Accenture, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / jaimy chacko
Compile the job and then run it- in the Job run option select the "Abort Job after" and give 100. So if there is 100 warnings(errors) the job will be aborted.
| Is This Answer Correct ? | 24 Yes | 2 No |
In the designer, After Compiling the job and then click on
run.in the Job run options, u will find 3 TABs :Parameters,
Limits, General. Go to Limits TAB, select the "Abort Job
after" and change it to 100. after 100 warnings(errors) the
job will be aborted.
by default it will set to 50
warnings.
| Is This Answer Correct ? | 17 Yes | 0 No |
Answer / xxx
by default it will set if job has more than 50
warningd,then job will abort.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / satya
U can use UtilityAbortToLog() function in transformer to
abort the job.
| Is This Answer Correct ? | 0 Yes | 2 No |
Answer / bietl
Hi,
You can use the Transformer stage,we have an option called
abort rows just mention the value it will abort once it
reach that count.
hope this will help you..
| Is This Answer Correct ? | 3 Yes | 13 No |
how to sort two columns in single job in datastage.
What is the function in Transformer stage can act as Rank Function in oracle
5) A file contains 10 (1-10) I want trgt like Trgt 1 trgt 2 trgt 3 1 2 3 4 5 6 7 8 9 10
What is the process of killing a job in datastage?
What is a delta record? How you will read it?
Wat is pre-load in Hashed file
If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?
What is usage analysis in datastage?
in oracle target stage when we use load option and when we use upsert option?
can we half project in parallel jobs and half project in server jobs?
I am getting input value like X = Iconv(“31 DEC 1967”,”D”)? What is the X value? How it is? At what situation we r used Iconv(),Oconv().
Hi friends,Two input files, wants to validate only if the reference data has '0' otherwise no validation should be done..how to do this??
Teradata 
