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
- 6484 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 |
How complex jobs are implemented in datstage to improve performance?
source file contains 100 records, i want 10 records in target file how it possible in datastage
If you want to use the same piece of code in different jobs, how will you achieve it?
in one scenario source flat file like Fileld1 00122001550056200568 00256002360014500896 00123004560078900258 00147004560025800256 divide each 5 numbers as one column i.e here i need field1 field2 field3 field4 00122 00155 00562 00568 00256 00236 00145 00896 00123 00456 00789 00258 00147 00456 00258 00256 plz help me....
What are stage variables and constants?
how can we send even and odd records from a sequential file to two different targets
10 Answers IBM, iGate, TCS,
what r the stages mostly used in realtime scenarios
what is a message handler
how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?
How to create a file using vi editor? 2)how to delete a file in vi editor? 3)How to connect the server datastage to unix? what r the command lines we r using? 4)30 jobs r runnig in unix i want to find out my job. how to do this? give me command?
what is the use of surogate key in datastage
how to identifie,is it innerjoin,leftouter join in lookup?
Teradata 
