How to split Input file into multiple output files based on number of records,also generating output file with unique sequence in Talend Open studio?
Hello Folks, Requirement : 1.Spliting Input file into multiple output files based on number of records.For example:Input file containing 20,000 records and we need to generate multiple output files(containing only 10,000 records). 2.Output file name with sequence For example: On day 1,File generated as FileName_ 001 .csv. On day 2.File must be generate as FileName_ 002.csv. There are multiple option to achieve this target but I will explain you 2 options in most optimized way. Option 1 : This requirement is Interesting because as we know that we can generate or split output file based on rows (standard feature of tFileOutputdelimited component provided by Talend). As when file generated as output it automatically add sequence also in file name. But this option cannot be opted for following 2 reasons: 1.when we need our desired sequence number as it starts from 1 but we want to generate it from 10. 2.Everyday when job will executed it will generated from 1 sequence only not ...
