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

Hi Can any one help regarding below INPUT NAME LOC Ram hyd Ram ban Raj chn Raj Pun Sam del OUPUT NAME LOC Ram Hyd ban Raj chn pun sam del

3 Answers   HCL,


What is quality stage?

0 Answers  


What are the types of views in datastage director?

0 Answers  


how to remove duplicates in transformer stage by using stage variables?one example?

6 Answers   Syntel, TCS,


What is container and then types?

1 Answers  


What is "fatal error/rdbms code 3996" error?

0 Answers  


Can you explain engine tier in information server?

0 Answers  


How to create user defined environment varibale(parameter)?

1 Answers   TCS,


Can you explain kafka connector?

0 Answers  


Hi guys, In sequencer job, we have 3 sources, in that 1st source have some records, Here requirement is 1st source records are 100 then only run the job otherwise total job will abort... How to calculate this. please design the job. Thanks.

1 Answers   IBM,


What is process model?

0 Answers  


where we use config file as parameter ?

1 Answers   IBM,


Categories