Hi, Please I am trying to load a FlatFile from a local drive using ( tFileInputDelimited to a tBigQueryOutPutBulk), But The number of rows transferred is lesser than the number in the input file
the data is separated with ; (semicolon) and the Text qualifier is "", example of a row will be like "16711";"20160101";"Oct 28 2017 9:32AM"
The Input is using this Definition is as below
Below is the component setting
The only thing I read on the talend help page is that if any of the columns is non nullable then , the row will be removed if null, but in my schema definition I made sure all the columns is nullable for the InputFile and the tBigQueryOutPutBulk, Please can anyone advice or point to anywhere I can check. I am using the open studio and new to talend. Thanks
Solved! Go to Solution.
Watch the recorded webinar!
Introduction to Talend Open Studio for Data Integration.
Test drive Talend's enterprise products.
Practical steps to developing your data integration strategy.