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
what is the use of skid in reporting?
How rejected rows are managed in datastage?
how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)
Why we use surrogate key?
Explain usage analysis in datastage?
What is the use of datastage director?
what is the use of surogate key in datastage
How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...
If you want to use the same piece of code in different jobs, how will you achieve it?
How do you remove duplicate values in datastage?
What is the difference between orabulk and bcp stages?
describe the Steps to confiure a Qlogic switch
How many types of stage?
What is the difference between the local container and shared container?
What are the functionalities of link partitioner?