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
Original Message:
Sent: 11-07-2019 11:10 AM
From: Rajesh Guttikonda
Subject: Javelin - Oracle source table to target table without Bulkupload
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