oracle stage

[laxmi_etl]

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

[narasimha]

Edited to delete: Found it not relating to parallel

[Sanket_Saraph]

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...

[thebird]

You can also do the same by using the Upsert Method and then putting the SQL Insert statement in the Update statement place holder - it will work...

Regards

The Bird.