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

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

Question Posted / sreenath

1 Answers
2841 Views
Cap Gemini, I also Faced
E-Mail Answers

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

There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this

0 Answers IBM,

I am having the 2 source files A and B and I want to get the output as, the data which is in file A and which doesn't in file B to a target 1 and which is in file B and which doesn't in file A to a target 2?

3 Answers

What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)

0 Answers IBM,

What is the use of datastage designer?

0 Answers

Explain entity, attribute and relationship in datastage?

0 Answers

wt is the diff b/w odbc and oracle stage

2 Answers Accenture, HCL,

What is the differentiate between data file and descriptor file?

0 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,

IS FILE SET CAN SUPPORT I/P AND O/P LINK AT A TIME?