What are the different database update actions available?



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

Nls stands for what in datastage?

0 Answers  


Name the different sorting methods in datastage.

0 Answers  


I want capture UnMatched records from Primary source and secondary source in JOIN stage?

3 Answers   TCS,


5) A file contains 10 (1-10) I want trgt like Trgt 1 trgt 2 trgt 3 1 2 3 4 5 6 7 8 9 10

2 Answers  


how do you pass parameters in a script?

1 Answers   L&T,






what is ds administrator used for?

0 Answers  


How to Convert the columns into rows?

2 Answers  


What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?

0 Answers  


my source seq file have col1 1 2 3 4 5 6 7 8 9 i have 4 targets t1 t2 t3 t4 1 2 3 4 5 6 7 8 9 like this how we can get?

10 Answers   Polaris,


what is a nodemap constraint

2 Answers   IBM,


What are the different types of lookups in datastage?

0 Answers  


What is container and then types?

1 Answers  


Categories