How to load TFilelist files data to multiple Oracle output tables

Four Stars

How to load TFilelist files data to multiple Oracle output tables

Hi,

 

in my job, I have to fetch a list of files using a tfilelist component.

I have to test for each file if the period written in the file name corresponds to the period inside the file if it is ok I must recover the schema of the file and insert the data into a table.

I have to do this processing for each file in the source directory.

 

PS: for each file I have a target table (loutput differs from one file to another)

 

 

best regrads

Moderator

Re: How to load TFilelist files data to multiple Oracle output tables

Hello,

Could you please let us know if this related thread helps?

https://community.talend.com/t5/Design-and-Development/How-to-load-TFilelist-files-data-to-multiple-...

Best regards

Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Four Stars

Re: How to load TFilelist files data to multiple Oracle output tables

hi,

 

it's not exactly the same problem because before this step I did iteration

tdbinput -> tflowtoiterate -> tFilatelist -> tjava

in the output of the component tjava I can not recover all the values.

 

 

Best regards

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog

Best Practices for Using Context Variables with Talend – Part 3

Read about some useful Context Variable ideas

Blog