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
- 6485 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
What are some prerequisites for datastage?
Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how
What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?
Notification Activity
What is the use of hoursfromtime() function in transformer stage in datastage?
What are the types of jobs we have in datastage?
How do you reject records in a transformer?
Define orabulk and bcp stages?
What are some different alternative commands associated with "dsjob"?
What is datastage engine?
how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)
What are the various kinds of the hash file?
What are data elements?
what are the devoleper roles in real time? plz tell i am new to datastage....
How to read the length of word in unix?
