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
- 5805 Views
- IBM, I also Faced
- E-Mail Answers
Answer / 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 |
how many dimentions and fact tables used in your project and what are names of it?
wt is the difference between swith and filter stage
Define orabulk and bcp stages?
Hi Every one, I have a scenario plz suggest me 1)On daily we r getting some huge files data so all files metadata is same we have to load in to target table how we can load? 2) One column having 10 records at run time we have to send 5th and 6th record to target at run time how we can send? Hi plz help me for above scenarios and If any one is having JobSequence kindly send me one example and the scenario to my mail ID(nrvdwh@gmail.com)
what is factless fact table?
IS IT POSSIBLE TO USE DATASET AS A SOURCE FILE?
What is the Difference Between DataStage 7.5 version and 8.1 Version?
Can you explain link buffering?
Please Tell me..,I need some Complex Jobs in datastage as per in interview?how to tell and how to explain?please send as well as posiible please
What is quality stage?
Hi Vijay here For Four CPU's how many nodes will required?
DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks
Teradata 
