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
- 24695 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 |
cust id,cust quty like 1,101;1,102;1,103 i want output like cust id,cust quty 1 101,102,103 in oracle please write a query in oracle
table actions available in oracle connector?
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??
How you can fix the truncated data error in datastage?
I have a few records all are same structures data, I want to store data in multiple targets how?
i have source like balance,drawtime 20000, 8.30 50000,10.20 3000,4.00 i want target like this balance,drawtime 20000, 20.30 50000,22.20 3000,16.00
A flatfile contains 200 records.I want to load first 50 records at first time running the job,second 50 records at second time running and so on,how u can develop the job?pls give the steps?
Differentiate between datastage and informatica?
Source flat file contains src --- 1 2 ' ' ' 18 we had 3 targets T1 T2 T3 -- -- -- 1 4 7 2 5 8 3 6 9 10 13 16 11 14 17 12 15 18 How can i get? **Using only datastage, but not unix or any other. I am expecting the answer soon.. Thanks in advance.
what is hash file
Hi , Today 1000 records updated, tomorrow 500 records updated how to find that?
How can u execute the sql query through unix? What is the Primary key for Dimension table? what is the primary key for Fact table?
Teradata 
