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 |
A flat file contains 200 records. I want to load first 50 records at first time running the job, second 50 records at second time running and so on, how u can develop this job?
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.
if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?
I am having two tables called MASTER and DETAIL. I want to insert records to both tables. But one condition is that whenever the insert for MASTER table is success then only the records will inserted into the DETAIL table, otherwise abort the job. How can u design this job?
On which interface you will be working as a developer?
in oracle target stage when we use load option and when we use upsert option?
what is main difference between change capture and change apply stages
describe the Steps to confiure a Qlogic switch
1) In a dataset how to delete a single row? 2) i have 50 rows , i want to display 5-7 records only? How to write the sql query? 3)i have 40 rows,i want to display last row? write sql query?
Star Schema vs. Snow Flake Schema. What is the best model for DW? Give example for both the models performance wise?
I have 5 different sources i want same records in 5 different targets Can you any body send me this question answer rathdsetl@gmail.com
Explain the situation where you have applied SCD in your project?