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 job control?
What all the types of jobs you developed?
What is oci?
What could be a data source system?
What are system variables and sequencers in datastage
Define Routines and their types?
What are the main differences you have observed between 7.x and 8.x version of datastage?
client know skid info?
sed,awk,head
What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)
how to use self join using datastage ? can u tell me using stage how can we implemnet the self join
1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?
Can you define merge?
what is the difference between == and eq in UNIX shell scripting?
How to perform incremental load in datastage?