I am having two tables called MASTER and DETAIL. I want to insert records to bo

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?

Question Posted / vijayp.dw

1 Answers
6593 Views
TCS, I also Faced
E-Mail Answers

I am having two tables called MASTER and DETAIL. I want to insert records to both tables. But one c..

Answer / 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

More Data Stage Interview Questions

1)Source file contains one record, I want 100 records in target file.

3 Answers

How one source columns or rows to be loaded in to two different tables?

0 Answers

Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?

0 Answers HCL,

how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara

0 Answers

Is the value of staging variable stored temporarily or permanently?

0 Answers

whats relation between configuration file and datasets?

2 Answers L&T, Wipro,

How do u set a default value to a column if the column value is NULL?

7 Answers HP,

Parallel job contains more than 20 stages. I want to find out which stage is more performance incentive.

1 Answers IBM,

Converting Vertical PIVOTing without using PIVOT stage in DataStage. Ex: DEPT_NO EMPNAME 10 Subhash 10 Suresh 10 sravs Output: DEPT_NO EMP1 EMP2 EMP3 10 subhash suresh sravs 2) How to implement Horizontal PIVOTing without using PIVOT stage.

3 Answers Cognizant, UHG,

Hi any one has datasatge 8.5 certication dump could you please provide your details i will contact you. send reply to my mail rajaadivi@gmail.com Thanks in Advance

2 Answers

what is push and pull technique??? I want to two seq files using push technique import in my desktop what i will do????

1 Answers TCS,

im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination

0 Answers

For more Data Stage Interview Questions Click Here