Interested to Buy Any Domain ? << Click Here >> for more details...
Hi guys,
In sequencer job,
we have 3 sources, in that 1st source have some records,
Here requirement is 1st source records are 100 then only run
the job otherwise total job will abort...
How to calculate this. please design the job.
Thanks.
- 1 Answers
- 5949 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / anil
Hi,
We can do it with one seq job and one parallel job
First create parallel job (p1) that calculates aggregate count. If aggregate count is less than 100 then abort the parallel job
Paralled Job Design(P1)
1. Take the data from source.
2. Add a column generator with column name as Temp and its value as A
3. Add aggregrator stage, where group by column is Temp and calculation is count rows. So after aggregation, count will be calculated and stored in Total Count column.
4. In the transformer, add a constraint for output link to a peak stage saying totalcount < 100 and abort after 1 row.
SO if count is greater than 100, parallel job (P1) is successful, Else failed
Sequence Job
1. Add parallel job(p1) to the sequence and add exception handler and terminator activity stage.
2. After P1 you can create whatever sources you want to as a each parallel job.
3. Add automatically handle failed activities in the sequence job properties
Now if P1 fails, sequence fails else rest will run.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
How to reverse the string using SQL?
How many types of stage?
What is the difference between in process and inter process?
Highlight the main features of datastage?
What are data elements?
What are stage variables and constants?
1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)
how to abort the job its matain duplicates?
What is aggtorec restructure operator?
What is merge stage?
What are the types of hashed files in data stage
how to run a sequential file stage in parallel if the stage is used on the TARGET side
root tree will find which is server job and which is parallel job?
How do you start developing a datastage project?
What are the important features of datastage?
