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
- 6697 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / subhash
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 |
Post New Answer View All Answers
Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...
Nls stands for what in datastage?
What is datastage engine?
What is orabulk stage?
how do u catch bad rows from OCI stage? And what CLI stands for?
How a source file is populated?
What are constraints and derivations?
hi iam new to this tooliam cmpltied to know abt datastage so now iam in project tell me whole step by step what iam doing iwnt to go with exp so plz hlp me pals
What is the importance of the exception activity in datastage?
What are data elements?
Describe link sort?
1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do
What are the functionalities of link partitioner?
how to implement scd2 in datastage 7.5 with lookup stage
how many rows sorted in sort stage by default in server jobs
