HOW CAN WE ABORT THE JOB IF THE RECORDS OF SOURCE FILE
CONTAINS VALUE AS 'VIJAY'?



HOW CAN WE ABORT THE JOB IF THE RECORDS OF SOURCE FILE CONTAINS VALUE AS 'VIJAY'?..

Answer / d anil babu

hi this is anil.


seqfile---->transformer----->dataset

in transformer take constrain and in that ename=vijay and give
value 1 abort after rows in consrain window

Is This Answer Correct ?    16 Yes 0 No

Post New Answer

More Data Stage Interview Questions

What is the difference between datastage and informatica?

0 Answers  


i have the source from Uk,north america how can i pass the data two tables based on the locations

2 Answers  


What modeling tool do you use?

6 Answers   HP,


one file contains col1 100 200 300 400 500 100 300 600 300 from this i want to retrive the only duplicate like this tr1 100 100 300 300 300 how it's possible in datastage?can any one plz explain clearley..........?

8 Answers   IBM,


what is the best stage in datastage parller jobs to use full out join and why

5 Answers   Virtusa,






if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables?chandu how can i implement scd typ1 and type2 in both server and in parallel?chandu field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the ,inthe fields?

2 Answers  


What is a delta record? How you will read it?

0 Answers   EDS,


I want capture UnMatched records from Primary source and secondary source in JOIN stage?

3 Answers   TCS,


What are iconv and oconv?

0 Answers  


Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?

0 Answers   ABC, TCS,


if a column contains data like ram,rakesh,madhan,suraj,pradeep,bhaskar then I want to place names separated by commas in another columns how can we do?

5 Answers  


How to display errors in datastage?

1 Answers   TCS,


Categories