What are the different database update actions available?

Question Posted / ram

1 Answers
10073 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

can we see the data in fixed width file? how can u change the datatype of fixed width files?

1 Answers Infosys,

Tell me the syntax of Configuration file?

1 Answers

if the source file is CID,CCODE,CONNDATE,CREATEDBY 0000000224,1000,20060601,CURA 0000000224,2000,20050517,AFGA 0000000224,3000,20080601,TUNE 0000000225,1000,20020601,CURA 0000000225,2000,20050617,AFGA 0000000225,3000,20080601,TONE AND TARGET is oracle following are the validations cid loaded with unique records leading zeors has to be deleted while loading cid in target load only customer who got early connected to company conn_date should be loaded into oracle date format cid datatype is varchar2 in target conn_date is data datatype ccode is varchar2 0000000224,1000,20060601,CURA 0000000224,1000,20060601,CURA

2 Answers

how can we create rank using datastage?what is the meaning of rank?

0 Answers IBM,

Define data aggregation?

0 Answers

Hi This is Vijay, How can your remove the duplicates in sequential File?

15 Answers HCL, Scope International,

guys pls tell me where we use sequence jobs exactly in realtime proj explain pls with example.

2 Answers TCS,

How to reverse the string using SQL?

0 Answers CTS,

What is ds designer?