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 difference between hashfile and sequential file?
how to add a new records into source?
How one source columns or rows to be loaded in to two different tables?
How do you import and export the datastage jobs?
WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE
What are stage variables, derivations and constants?
What is size of a transaction and an array means in a datastage?
What are the primary usages of datastage tool?
What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?
Define project in datastage?
What is difference between symmetric multiprocessing and massive parallel processing?
What is merge stage?
Highlight the main features of datastage?
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
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