Hi guys,
Design job sequence,
we have 3 sources, in that 1st source in abort then only run
the remaining sources..
How please design the job.
Thanks.
Answers were Sorted based on User's Feedback
Answer / ankit gosain
Hi All,
Create three job acitivities like:
JobActivity1-------->JObAcitivity2
|
|
|
JobActivity3
Now, double click on JobActivity1, and go to the trigger
tab, make the expression type for both the JobActivity2 &
JobActivity3 as failed - (Conditional).
Then both the jobs will run if and only if when the first
job will get aborted.
Cheers,
Ankit :)
Is This Answer Correct ? | 1 Yes | 1 No |
What is active and passive stage?
Lookup constraints
How to lode data in sequntional files perform faster?
Emp login_timestamp Logout_timestamp A,2019-02-01 02:24:15,2019-02-01 04:59:42 B,2019-03-29 14:43:30,2019-03-29 20:22:00 ABC,2019-03-29 12:43:00,2019-03-29 23:22:59 In the above calculate the duration of hours spent in office for each emp in datastage.
Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC
how to find out number of records imported into source file?
how can we create rank using datastage?what is the meaning of rank?
What is Cleanup Resources and when do you use it?
What is lookup table?
How did you reconcile source with target?
What is the difference between operational data stage (ods) and data warehouse?
explain how to create SCD-2 IN DATASTAGE 7.5X2 PLZ EXPLAIN WITH 4 OR 5 RECORDS TAKE IT EXAMPLE AND JOB DESINGN URGENT