Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have developped 5 jobs, each one generate a file : file 1 : CCR , file 2: DENT,file3: PLI, file4: COMMISSION , file5: BVC.
now i want to generate a csv file counting number of rows generated from tables of each job.
remarque: each job generate new result every 15 minutes.
Please if there is any suggestions for building this job , post them as soon as possible.
Hi,
If you want to identify the number of records loaded in each job load, you an use NB_LINE paramater for that output component and print it (or store it to a variable for future use). In below job, I was able to create a sample of 10 records and I loaded them to a file. I am printing the data later into console using java String.out command.
In the tjava, I gave Control+Space to get the variable as shown below.
If the answer has helped to resolve your query, could you please mark the topic as resolved? Kudos are also welcome 🙂
Warm Regards,
Nikhil Thampi