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



Hi guys, Design job sequence, we have 3 sources, in that 1st source in abort then only run the..

Answer / babu

hai Ankit,

we have to give only for jobactivity1(failed conditional),
remaining jobactivity2 and jobactivity3 have unconditional otherwise ok conditional...

(I think)


thanks.

Is This Answer Correct ?    6 Yes 2 No

Hi guys, Design job sequence, we have 3 sources, in that 1st source in abort then only run the..

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

Post New Answer

More Data Stage Interview Questions

What is active and passive stage?

0 Answers  


Lookup constraints

0 Answers   CTS,


How to lode data in sequntional files perform faster?

1 Answers   Polaris,


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.

1 Answers  


Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC

0 Answers   CTS,






how to find out number of records imported into source file?

1 Answers  


how can we create rank using datastage?what is the meaning of rank?

0 Answers   IBM,


What is Cleanup Resources and when do you use it?

2 Answers  


What is lookup table?

5 Answers  


How did you reconcile source with target?

2 Answers   HP,


What is the difference between operational data stage (ods) and data warehouse?

0 Answers  


explain how to create SCD-2 IN DATASTAGE 7.5X2 PLZ EXPLAIN WITH 4 OR 5 RECORDS TAKE IT EXAMPLE AND JOB DESINGN URGENT

3 Answers   IBM, Polaris,


Categories