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 |
How to Remove Duplicate using SQL?
hi i am bhavani, in real time data stage who is the source provide? and how to recevied in developer? Pls send me answer
which cache supports connected & un connected Lookup
I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?
source file contains 100 records, i want 10 records in target file how it possible in datastage
HOW CAN WE SEE THE DATA IN DATASET?
What is usage analysis in datastage?
tab1 tab2 1,a 1,d 2,b 3,c perfoms outerjoin what is the o/p? write sql query for outerjoin?
while we using change capture stage we have to be take two table thats are 1.before table 2. after table . what is before table and after table please give me clear notation Thank You very much in advance
how to sort two columns in single job in datastage.
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.