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
- 6558 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
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this
What are orabulk and bcp stages?
What are the different layers in the information server architecture?
What is oci?
What are the benefits of datastage?
Can you explain how could anyone drop the index before loading the data in target in datastage?
What are the types of containers and how to create them?
What are the functionalities of link partitioner and link collector?
What are the components of datastage?
What is apt_config in datastage?
how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.
What is ds designer?
What are the various kinds of the hash file?
What is orabulk stage?
