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
- 5646 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 |
if a column contains data like abc,aaa,xyz,pwe,xok,abc,xyz,abc,pwe,abc,pwe,xok,xyz,xxx,abc, roy,pwe,aaa,xxx,xyz,roy,xok.... how to send the unique data to one source and remaining data to another source????
How do you generate sequence number in datastage?
guys pls tell me where we use sequence jobs exactly in realtime proj explain pls with example.
To see hidden files in LINIX?
WHAT are unix quentios in datastage
How to display errors in datastage?
what is parameterset?
how many write modes are there in ds
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 difference between Datastage 7.5 and 7.0?
Can you filter data in hashed file?
Star Schema vs. Snow Flake Schema. What is the best model for DW? Give example for both the models performance wise?
Teradata 
