insert multiple files using bulkexecute

Anonymous — Wed, 14 Nov 2018 13:05:39 GMT

I have a task where we need to retrieve the data from multiple tables and then store them to different database with similar structure.

So I have created a configuration table where all the required queries are written to pull the data and by iterating that i am able to create the delimited output files . I have used dynamic schema feature to handle the columns.

Now i want to insert those files to destination database using dynamic schema. But I am facing two Issues

1. while passing the table name from the global variable it gives error that table doesn't exist . The root cause behind this is the table is enclosed with " ".

2. Not able to set the schema dynamically.

Re: insert multiple files using bulkexecute

Anonymous — Wed, 28 Nov 2018 08:18:12 GMT

Hello,

To use bulk load you have to add fields definition into the bulk file or into an other file.

Best regards

Sabrina

topic Re: insert multiple files using bulkexecute in Talend Studio

insert multiple files using bulkexecute

Re: insert multiple files using bulkexecute