In a table 100 records are there after 50records job is aborted how can u insert all records in target table.



In a table 100 records are there after 50records job is aborted how can u insert all records in targ..

Answer / sreenath

I'm not sure .......
In Oracle database target stage u have a options insert/upsert option u can put that option everything false into place

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Data Stage Interview Questions

Explain the situation where you have applied SCD in your project?

0 Answers  


specify data stage strength?

1 Answers  


I am getting input value like X = Iconv(ā€œ31 DEC 1967ā€,ā€Dā€)? What is the X value? How it is? At what situation we r used Iconv(),Oconv().

1 Answers   Amdocs, TCS,


i want job aborted after some records are loaded into output by using only sequential stage and dataset

1 Answers   IBM,


WHAT IS FORCE COMPILE?

3 Answers   FIS, HCL, Polaris,






What can we do with datastage director?

0 Answers  


source contains 2 columns comes to target 4 columns how

1 Answers   IBM,


Unix Qn asked in datastage interview: I have diff type(.txt, .tmp, .bat etc) of file in 4 diff directories, I want move all '.txt' file from 4 directories to other folder. And need to delete all the files except which are created TODAY?

2 Answers   TCS,


In the source seq file have 2 columns, i.e input: col1,col2 1,1 2,rajesh 3,15000 4,2 5,suresh 6,16000 7,3 8,veeru 9,17000 I want in the output like: eno,ename,sal 1,rajesh,15000 2,suresh,16000 3,veeru,17000 any one answer this scenario

3 Answers  


What is Fastly Changing Dimension?

6 Answers   TCS,


country, state 2 tables r there. in table 1 have cid,cname table2 have sid,sname,cid. i want based on cid which country's having more than 25 states i want to display?

3 Answers   Wipro,


What is the default padding character?

3 Answers   IBM,


Categories