Hello We stopped discovering files, that did not lead to the result we expected. Instead we have started defining an interface specification in csv/xls, this contains all the required information (and can in must cases directly be generated from the ...

Yes, we do something similar, we actually have >2'000 small files (10-50 rows) which we want to load all into the same table, each of the files has 2 header rows(1 row column names, 2 row datatype definition). The files reside on an sftp-server.We ha...

Hello NituWakanWhen we started with the migration from Teradata to Exasol Wherescape's standard for Exasol was also PowerShell. We absolutely did not like this approach, because we didn't want to introduce another language, it was not transparent and...

Hello ChrisDefinitely, however I would suggest that we first show that it works. Therefore I would suggest that we wait until we have at least one part of our datawarehouse in production (the plan was to have the first part by end of October in produ...

Hello ValerieMany thanks. This makes it easier to select the right tool/language for the right purpose. As we are about to introduce EXASOL in our company I was asked a lot which language we should choose.Kind RegardsGallus