What are the different database update actions available?

Question Posted / ram

1 Answers
10211 Views
HP, I also Faced
E-Mail Answers

What are the different database update actions available?..

Answer / fahmida

In server jobs three types of Updates are available,
Update Existing Rows Onlly
Update Existing Rows Or Insert New rows
Insert New rows or Update Existing Rows

In Parallel jobs two types of Update actions are available,
Update
Upsert

Is This Answer Correct ?

5 Yes

1 No

Post New Answer

More Data Stage Interview Questions

How to read the length of word in unix?

0 Answers CTS,

how to create document in datastage?

1 Answers Cap Gemini,

how to handle null values using transformer stage?

1 Answers

how can u connect the client system directly at any time?

1 Answers IBM,

what is the difference between lookup stage reject link and merge stage reject link in datastage Parallel jobs? interm of output in Merge Reject link and Look Up Reject link ?

4 Answers HCL,

source file is having 5 records while moving into target it want to be 10 records

4 Answers IBM,

can a fact table contains textual information

6 Answers HCL, HCL BSERV, IBM,

Define meta stage?

0 Answers

In one project how many shared containers are created?

3 Answers NTT Data,

what is Audit table?Have u use audit table in ur project?

3 Answers Accenture, Wipro,

how can we create tables in datastage?

1 Answers

how to convert rows into columns

2 Answers IBM,

For more Data Stage Interview Questions Click Here