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
- 5849 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 |
What could be a data source system?
In aggregator stage,to find the sum of the entire group of columns,it displays in binary format. How can i solve this problem.
I have a source table with column name CITY having 100 records, I want target table with column name start with 'A' and 'B',remaining columns as reject outputs. how can achieve this by data stage?please help me?????
How do you design PX Routines ?
what is the difference between == and eq in UNIX shell scripting?
How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...
0 Answers Alpharithm Technologies,
Why fact table is in normal form?
What is the difference between lookup and sparse lookup?
What is the use of surrogate key stage?
What is the use of datastage director?
1.what is materialized data? 2.how to view the materialized data?
in datastage interview qustion source target ------- ------- 12345 1 2 3 4 5
Teradata 
