i want job aborted after some records are loaded into output
by using only sequential stage and dataset



i want job aborted after some records are loaded into output by using only sequential stage and dat..

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

Post New Answer

More Data Stage Interview Questions

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)

0 Answers  


How do you register plug-ins?

0 Answers  


how to unlock a locked job in datastage 8.0

3 Answers   HCL,


how to use self join using datastage ? can u tell me using stage how can we implemnet the self join

0 Answers  


Differentiate between operational datastage (ods) and data warehouse?

0 Answers  






What is the difference between hashfile and sequential file?

0 Answers  


What modeling tool do you use?

6 Answers   HP,


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.

4 Answers   iGate, Thirdware,


How to convert table data into xml file using xml output stage? please explain step by step;

2 Answers   IBM,


What are the difference types of stages?

0 Answers  


how many rows sorted in sort stage by default in server jobs

0 Answers   Syntel,


What are stage variables?

0 Answers  


Categories