I have created and exported a job a while back and it does convert csv files to tde. I have 900 csv files and they were separated into folders. I have a main folder and inside it is folder1 having the first 100 csv files then folder2 having the second 100 files..and so on. I have bat file that will call this exported job looping through all folders in Main folder. It was like below
echo "START TIME: %time%"
REM Loop through all stores and Run TDE Conversion
cd /D %~dp0
REM 373 Days Daily CSV to TDE
for /D /r E:\Main\Store %%a in (*) do ^
start E:\Main\ScheduleJobs\TDEConversion_373DaysDaily_0.1\TDEConversion_373DaysDaily\TDEConversion_373DaysDaily_run.bat %%a%
cd /D %~dp0
type nul > E:\Main\Store\TDEStore_Final373D.tde
echo "FINISH TIME: %time%"
My job consists of tfilelist > iterate > tfiledelimited >tmap>tTableauExtractOutput
In tfilelist I have checked global expression as filemask and filemask ="*.csv"
Now I needed to re-export the job...however it is not producing tde files as expected. What should i do..I need help here really badly
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema
Pick up some tips and tricks with Context Variables