1. Categories >> Software >> Data Warehouse >> Data Stage
  2. Suggest New Category

if ename='subbu' while running job the job should be abort
how come?

Question Posted / kkk

Answers were Sorted based on User's Feedback



if ename='subbu' while running job the job should be abort how come?..

Answer / rajesh

if inputlink.value='subbu' then call the function
DSLogFatal, which logs a fatal error and aborts the job.

Is This Answer Correct ?    2 Yes 0 No

if ename='subbu' while running job the job should be abort how come?..

Answer / datastage4you

Use the transformer stage to abort this job when empname is subbu


Thanks
www.datagenx.net

Is This Answer Correct ?    1 Yes 0 No

if ename='subbu' while running job the job should be abort how come?..

Answer / chinna

using grep command of unix we can do this

Is This Answer Correct ?    1 Yes 3 No

Post New Answer

More Data Stage Interview Questions

What is Fastly Changing Dimension?

6 Answers   TCS,

Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.

0 Answers  

How to work with XML out put stage? Please explain step by step? i need to generate XML file using Table data. Given is the .XSD file. Please help?

2 Answers   TCS,

How to remove ctrl M or(^M) characters in file using Sequential File stage?

2 Answers   Bank Of America, Satyam,

What is job control?

0 Answers  




Which type of joins Merge stage can support?

7 Answers   IBM,

source file having the data like aabbccc, i want target file result like a1a2b1b2c1c2c3.

2 Answers  

Can you explain link buffering?

0 Answers  

Wat is pre-load in Hashed file

1 Answers   Patni,

Differentiate between validated and Compiled in the Datastage?

0 Answers  

1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)

0 Answers   Polaris,

what is normalization and denormalization

2 Answers   CTS,

For more Data Stage Interview Questions Click Here
Categories