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 |
Which type of joins Merge stage can support?
What is staging variable?
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 you can fix the truncated data error in datastage?
if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?
j1,j2,j3 jobs r runing iwant to run j1,j3 after j2 how to do this using sequencer? 2)j1,j2,j3 jobs r runing iwant to run j1,j2,j3 how to do this?
Describe stream connector?
Enlist various types of routines in datastage.
wt is the difference between swith and filter stage
What is a ds designer?
Name the command line functions to import and export the DS jobs?
Give example for FACTLESS FACT TABLE in real-time scenario.