convertion of csv to tde get time

One Star

convertion of csv to tde get time

Hi,
I have a job that converts all CSV files in a folder into TDE. Once conversion is done, I have a subjob that will copy all generated TDE files to another destination. I do not know when the conversion will finished completely and trigger the subjob to run though I have used the SUBJOB OK trigger. Please see screen shot.
Now what I did is check the file size of the TDE generated using the tTableauExtractOutput component. If it is more than 30KB then it will execute the subjob but this also does not work. No file is copied. Please help. Thanks!
Community Manager

Re: convertion of csv to tde get time

You don't need runIf trigger, if all the conversions are finished, the next subjob linked with onsubJobOK will be executed. 
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: convertion of csv to tde get time

Hi Shong,
I also did that but the requirement should be all csv files must be converted first before running the next job. But the next subjob was executed before the conversion was finished because I added the condition that if it was more than 30KB then the file will be copied because it was converted completely. Is there a way that I would know when the conversion of csv to tde will be finished?
Regards!
Community Manager

Re: convertion of csv to tde get time

I also did that but the requirement should be all csv files must be converted first before running the next job. 

If you use onsubjobok link like:
tFilelist--iterate....tFileInputDelimited....
   |
onsubjobok
  |
tFileCopy
tFileCopy component will work only when the previous subjob finishes, means all of files are read and transformed completely. 
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: convertion of csv to tde get time

Hello Shong,
Appreciate all your help regarding this issue. Would you mind if we exchange email address so that we might be able to communicate faster.
Thank you.
Will send a PM to you.