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
- 6515 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 |
what are .ctl(control files) files ? how the dataset stage have better performance by this files?
What are system variables and sequencers in datastage
How to remove duplicates in transformer stage? in parallel mode
Parallel job contains more than 20 stages. I want to find out which stage is more performance incentive.
1.How do u handle NULL in sequential stage. 2.Difference between switch stage and filter stage.
Can you explain engine tier in information server?
How can we improve the performance in datastage?
How can one find bugs in job sequence?
how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?
what is the difference between the join and look up explin me one exmple
Can you explain players in datastage?
If you want to use the same piece of code in different jobs, how will you achieve it?
Teradata 
