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
- 6589 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 is the difference between an operational datastage and a data warehouse?
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
Differentiate between data file and descriptor file?
What are the steps needed to create a simple basic datastage job?
What are the repository tables in datastage?
root tree will find which is server job and which is parallel job?
Can you highlight the main features of ibm infosphere information server?
how to add a new records into source?
How you can fix the truncated data error in datastage?
How do you import and export data into datastage?
Where the datastage stored his repository?
What are constraints and derivations?
Differentiate between Join, Merge and Lookup stage?
What are the types of jobs we have in datastage?
