Store SQLinput in json files, one row in one file

Anonymous — Fri, 27 Dec 2013 14:58:30 GMT

Hi!
I want build a job, which will read sql table and store each row in json file.
Which job structure is better for this?
Dmitry.

Re: Store SQLinput in json files, one row in one file

Anonymous — Fri, 27 Dec 2013 16:03:34 GMT

tOracleInput ----> tFileOutputJSON
Or do I miss something from your use case?
Did you mean every row in its own JSON file?
In this case:
tOracleInput ----> tFlowToIterate ----> tFixedFlow (set the variables from tFlowIterate!) ----> tFileOutputJSON (use any variable from tFlowToIterate to build the file name)

topic Re: Store SQLinput in json files, one row in one file in Talend Studio

Store SQLinput in json files, one row in one file

Re: Store SQLinput in json files, one row in one file