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
2914 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

what is data mapping

2 Answers

Hi, Please tell me how to solve this scenario in datastage ? Here we have 3 columns in a table TEST CODE,ENTRY DATE and BATCH The table looks like CODE ENTRYDATE BATCH 100 100716 1 100 100716 1 100 100716 1 200 122517 2 200 122517 2 302 555555 8 302 555555 8 302 555555 8 We need to create a seqno on grouping these 3 columns. The result should be like this. CODE ENTRYDATE BATCH SEQNO 100 100716 1 1 100 100716 1 2 100 100716 1 3 200 122517 2 1 200 122517 2 2 302 555555 8 1 302 555555 8 2 302 555555 8 3

1 Answers Alpharithm Technologies,

How to remove duplicates in transformer stage? in parallel mode

6 Answers Syntel, TCS,

Describe the main features of datastage?

0 Answers

Differentiate between data file and descriptor file?

0 Answers

WHAT are unix quentios in datastage

2 Answers TCS,

How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.

0 Answers CTS,

when u face critical situation in ur project, how to solve them?