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 |
LIST THE BUILT-IN STAGES AVALIABLE IN SERVER JOBS?
file1 1 2 3 4 file2 3 4 5 6 output should be in three targets T1 T2 T3 1 3 5 2 4 6 how to do this? can any one help? Thanks
Source flat file contains src --- 1 2 ' ' ' 18 we had 3 targets T1 T2 T3 -- -- -- 1 4 7 2 5 8 3 6 9 10 13 16 11 14 17 12 15 18 How can i get? **Using only datastage, but not unix or any other. I am expecting the answer soon.. Thanks in advance.
i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS
1)What is configuration your file structure 2)I have two databases both are Oracle while loading data from source to target the job takes 30 min but I want to load less time how?
Why we use parameters instead of hard code in datastage.
How to display all the duplicate records from the oracle Table?
What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?
What are the steps needed to create a simple basic datastage job?
What are the stages in datastage?
What are the various kinds of the hash file?
In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?