i want job aborted after some records are loaded into output
by using only sequential stage and dataset
Answer / guest
HI Friend,
Use constraint in transformer stage by selecting abort after
rows column and mention the no.of rows to be rpocessed, then
after those many rows job will abort.
Thanks,
Hanumantha Rao.
Is This Answer Correct ? | 0 Yes | 1 No |
how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)
How do you register plug-ins?
how to unlock a locked job in datastage 8.0
how to use self join using datastage ? can u tell me using stage how can we implemnet the self join
Differentiate between operational datastage (ods) and data warehouse?
What is the difference between hashfile and sequential file?
What modeling tool do you use?
Scenario : I have 2 jobs say job A and Job B with parameters x and y respectively. I need to create a sequence job. If we pass parameter x then Job A should run, If we pass parameter y then Job B should run, if we dont pass any parameter then Both Job A & B should run.
How to convert table data into xml file using xml output stage? please explain step by step;
What are the difference types of stages?
how many rows sorted in sort stage by default in server jobs
What are stage variables?