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.
Watch the recorded webinar!
Part 2 of a series on Context Variables
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema