Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I'm using TOS and I need to pass records as a batch to a subjob as if, for example, the subjob were reading a single CSV file. However I don't want to use an intermediate file.
My first thought is using a Java list in the global map where to put my records into, and then declare a parameter of type Object in the subjob.
Are there any better ways? Can this be achived using properly configured components instead of Java code?
Thanks in advance,
Mick
There is a really easy way of doing which also opens up many other possibilities for working with your data.....but it isn't well known. You can use the tHSQLDBOutput and tHSQLDBInput components and load your data into memory. Load it into memory using the tHSQLDBOutput and then read it back (using SQL....so you can filter, join, etc) within your child job.
An example is given here.....
https://community.talend.com/s/feed/0D75b000005yRDCCA2