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
- 5712 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 to sort two columns in single job in datastage.
I have a file it contain 2 records like empname,company as Ram, Tcs and Ram, IBM. But i want empname, company1,company2 as Ram, TCS,IBM in the target. How?
Star Schema vs. Snow Flake Schema. What is the best model for DW? Give example for both the models performance wise?
What is difference between symmetric multiprocessing and massive parallel processing?
how to clear the source file? 2) diff b/t odbc & Oracle?what is node? 3) explain one complex job u face in ur project
how do u catch bad rows from OCI stage? And what CLI stands for?
Question 4) source target c1 c1 c2 c3 c2 c4 c4 c5 c3 c6 c7 c4 c5 c6 c7 Singal Source and Singal Target only subash,
can we see the data in fixed width file? how can u change the datatype of fixed width files?
source file contains 100 records, i want 10 records in target file how it possible in datastage
What is container and then types?
Thanks to all people who are posting their comments...
How to convert alpha Numeric values to alpha using functions?
Teradata 
