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
- 6520 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
1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.
What are system variables and sequencers in datastage
Explain datastage architecture?
How to manage date conversion in Datastage?
What is ibm datastage?
Name the different sorting methods in datastage.
What is the difference between the local container and shared container?
How to read the length of word in unix?
How the ipc stage work?
Whats difference betweeen operational data stage (ods) and data warehouse?
What are the repository tables in datastage?
EXPLAIN SCD
What are the different types of lookups in datastage?
Differentiate between validated and Compiled in the Datastage?
disign the complex job in u r project?(they are aksing only complex job design and then data flow...)
