HI-
I have one question the problem is i have to load records from source to
target (actually i have to insert into the target) the database we are using is oracle. For this i am using oracle stage but here we have no insert option so what do we need to do can anybody help on this
Thanks
oracle stage
Moderators: chulett, rschirm, roy
Edited to delete: Found it not relating to parallel
Last edited by narasimha on Wed Nov 22, 2006 1:33 pm, edited 1 time in total.
Narasimha Kade
Finding answers is simple, all you need to do is come up with the correct questions.
Finding answers is simple, all you need to do is come up with the correct questions.
-
- Participant
- Posts: 20
- Joined: Tue Jun 13, 2006 5:16 am
- Location: Pune
Hi Laxmi,
If your data is clean and ready to satisfy the constraints of target table then there is no issue
,
using 'Load' method to load data in faster way.
Now if you want to insert data by user defined insert query then use upsert method(user defined insert and update).
Put your insert query uder insert tab and in update query under update tab put where condition as 1=2 so it will not update any record.
Regards,
Sanket...
If your data is clean and ready to satisfy the constraints of target table then there is no issue
![Laughing :lol:](./images/smilies/icon_lol.gif)
using 'Load' method to load data in faster way.
Now if you want to insert data by user defined insert query then use upsert method(user defined insert and update).
Put your insert query uder insert tab and in update query under update tab put where condition as 1=2 so it will not update any record.
Regards,
Sanket...