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
Describe the architecture of datastage?
Can you explain link buffering?
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
What are the various kinds of containers available in datastage?
How to Remove Duplicate using SQL?
Define repository tables in datastage?
What are routines in datastage?
Have you used Unstructured data?
What is job control?
How to reverse the string using unix?
What are the steps required to kill the job in Datastage?
What is the difference between datastage and informatica?
how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara
What is a quality stage in datastage tool?
What are the different options associated with dsjob command?