Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 1 Answers
- 6702 Views
- TCS, I also Faced
- E-Mail Answers
First Load the MASTER table.
Next, Load the DETAIL table with 'look up' on MASTER table.
In the look up, set the look up condition as 'FAIL'.
For each record from SOURCE, If the look up record is not
loaded into the MASTER table.. the job will 'Abort' on look up
failure.
| Is This Answer Correct ? | 8 Yes | 0 No |
What are some different alternative commands associated with "dsjob"?
in oracle target stage when we use load option and when we use upsert option?
How to initialize environment variables?
What is Cleanup Resources and when do you use it?
What is the difference between SQl Loader and OCI in datastage?
What can we do with datastage director?
col1 123 abc 234 def jkl 768 opq 567 789 but i want two targetss target1 contains only numeric values and target2 contains only alphabet values like trg1 123 234 768 567 789 trg2 abc def jkl opq
Thanks to all people who are posting their comments...
how to run jon in unix back round process what is command use in runing a job?
What are constraints and derivations?
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.
1.How do u handle NULL in sequential stage. 2.Difference between switch stage and filter stage.
Teradata 
