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 |
Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?
A flat file contains 200 records. I want to load first 50 records at first time running the job, second 50 records at second time running and so on, how u can develop this job?
Hi friends, I am new to datastage, i have one query in datastage any one you please give reply to my post. I have a workbook (excel sheet) named as eg: xxxx, in that i have two tables emp(eid, ename, salary, deptno) and dep(deptno, name, state). in my source i have ODBC enterprise stage read the emp table and dept table join the two table and write the dept no 10(eid,ename,salary,name,state) values in target(). Thanks, Badari
Differentiate between odbc and drs stage?
How to read multiple files at different directories using a single Sequential File stage in DS Enterprise Edition
can we see the data in fixed width file? how can u change the datatype of fixed width files?
what is the use of surogate key in datastage
What are the components of datastage?
Can aggregator and transformer stages use to sort the data? How ?
Define Job control?
Can you explain kafka connector?
1.which index is follows the dimensions tables?why? 2.what is the use of trigger in job sequence? 3.what is the mean of optimization? 4.what is the job control?when we use it? what is difference bet batch and sequencer? 6.seq--->seq,seq--->copy--->seq which one is best and efficient?