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 |
iam new to datastage...now i want to know what are fact tables, dimension tables in bank domain...if any body knows plz tell me asap..
What are the various kinds of the hash file?
how can find maximum salary by using Remove duplicate stage?
Source contains the metadata source ----- hyderabad,chennai,bangalore by using nested loop sequence select source as hyderabad in target just run target as hyderabad only not others please give me answer thanks in advance(give reply how to wrote logic using nested loop sequence)
what is a message handler
1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.
how to define satge variables in transformer stage
what is the definitions for Datawarehose and Datamart?
What is PX?
Why do you need stage variables?
What are the environmental settings for data stage,while working on parellel jobs?
What steps should be taken to improve Datastage jobs?