DSXchange

I have created a Server Shared Container with a Sequential File Stage to read my flat file. But I get an error, which says that I have a required column missing. I have specified 41 columns, because the longest record in the CSV file is 41 fields long. But the first record for example contains only ...

Indeed each section has a different end target. My first idea was to load the flat file to one staging table. And then I would use this staging table to load to the differtent target tables.

But it might be better to load every section to a different target staging table already.

I want to load the data of a CSV file into a DB2 database. The CSV file is quite complex as it contains different section and each sections has a different number of columns. So records of a csv file could be like: a,b,c d,f g,h,i,j,k,l,m Currently I am making use of the Sequential File Stage, I've ...