Javelin - Oracle source table to target table without Bulkupload

[Rajesh Guttikonda]

Hi All,
Is there any way in Javelin, we could insert data from source table to target table for Oracle with out using BulkImport utility.

Thanks
Rajesh

[Klaas-Jan Lute]

Hi Rajesh,

You could try the following: Use only one BulkCopy element with variables. If you put this in a ForEach element with a schema definition table you can manage the whole copy proces from within that table. I gave this table the follwing attributes:
[systeem]
,[schema]
,[db]
,[tablename]
,[type] ((C)onfiguration,(T)ransaction,(L)og,(R)eference)
,[subset] (Y/N)
,[comment]
,[connection] (the attribute with which to subset, f.i. the userid)
,[selection] (if it's different from a 'select *')
,[condition] (should you use a where clause)
,[relatie] (optional parent table)
,[relatie_id] (the linking attribute in the parent table)
,[sequence] (the hiërarchy)
So a query element returns these values and for each of these lines the values are transferred to variables with which the BulkCopy is run. 
"select * from "+varTabelnaam+" where "+varConditie+" and "+varConnectie+" in ( select nummer COLLATE Latin1_General_CI_AS from scramble.dbo.subset_selectie where systeem = '"+varSysteem+"' )"

No need to use GTSubset anymore and a Javelin workflow with just one bulkcopy element. For child records 

Best regards,
Klaas-Jan Lute