What are the different database update actions available?
Answer Posted / 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 View All Answers
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
Explain Quality stage?
how to implement scd2 in datastage 7.5 with lookup stage
What are the functionalities of link partitioner and link collector?
What is the difference between datastage and informatica?
How do you register plug-ins?
Explain the datastage parallel extender (px) or enterprise edition (ee)?
Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance
How will you move hashed file from one location to another location?
How do u convert the columns to rows in datastage?
What are the different options associated with dsjob command?
What are the different type of jobs in datastage?
Difference between in process and inter process?
Name the command line functions to import and export the DS jobs?