in oracle target stage when we use load option and when we
use upsert option?
- 1 Answers
- 2385 Views
- I also Faced
- E-Mail Answers
Answer / Prateek Chaudhary
In Oracle Target Stage, the Load option is used to create a new table or append data to an existing table if it doesn't exist. On the other hand, the Upsert option (Update or Insert based on a condition) allows you to update existing records in a table if they match a specified condition, and insert new records if no matching record is found.
| Is This Answer Correct ? | 0 Yes | 0 No |
i have a scenario with i/p as ID,salary with values 1,1000 2,2000 and 3,4000 i need an extra column in the o/p named amount with values 2000,4000 and NULL. how can i get it?
i have the source from Uk,north america how can i pass the data two tables based on the locations
Define repository tables in datastage?
What is datastage engine?
if a column contains data like ram,rakesh,madhan,suraj,pradeep,bhaskar then I want to place names separated by commas in another columns how can we do?
I have 5 different sources i want same records in 5 different targets Can you any body send me this question answer rathdsetl@gmail.com
what is combinability and non combinability?
in sequtial file 2 columns avaliable,iwant only one column load the target how do it.
how to retrive the max(sal),deptno,empno in datastage?
What is the Difference between Change capture stage and Difference Stage ? What are its significance individually ?
Explain Quality stage?
WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE
Teradata 
