i want job aborted after some records are loaded into output
by using only sequential stage and dataset
Answer / guest
HI Friend,
Use constraint in transformer stage by selecting abort after
rows column and mention the no.of rows to be rpocessed, then
after those many rows job will abort.
Thanks,
Hanumantha Rao.
| Is This Answer Correct ? | 0 Yes | 1 No |
input like 2 7 8 9 5 1 7 3 6 output:2 5 6 how to find out this plz explain?
can explain wt is the pool for file.
What is the purpose of interprocessor stage in server jobs?
What is ds designer?
1.When did 8.1 parallel came into existence? 2.What is the difference between 7.5 and 8.1?
Hi I have scenario like this s/r table T/r table ename,sal empno,ename,sal vijay,2000 1 , vijay, 2000 kumar,3000 2 ,kumar , 3000 ravi ,4000 3 ,ravi , 4000 How can i get target table like that without using Transformer stage?
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
at source level i have 40 columns,i want only 20 cols at target what r the various ways to get it
how to do pergformence tuning in datastage?
What is difference between symmetric multiprocessing and massive parallel processing?
Why we use surrogate key?
i have 3 diffrent tables. 1) US rate data 2)CANADA rate data and 3)MEXICO rate data. All 3 tables have 6 collumns each. 4 collumns are commun to all tables and 2 are diffrent. Now at target i want single table say Country rate which will have (4+2+2+2+1 flag) 11 collumns. I will add a flag collumn which will indicate country and will put nullable collumns which are not common to other. How i can implement this in datastage?