I guess the issue I'm having if we are moving a flat file to Teradata why doesn't Easy Loader assume all VARCHAR?
Does this mean we need to create a job variables files with the proper schema for the flat file (it would be all VARCHAR I assume)? We're not using one in 15.00.
I also still don't understand why we're seeing FLOATS from easy loader in 15.10 when it was previously all VARCHAR in 15.00?
You've always been very helpful, Steve, when I've posted in the forum. I appreciate all the time you have given to this question. We'll do our best to workaround this, but something doesn't seem right here. :/ Thanks again!!!
If you are loading data from a flat file to the Teradata Database, the schema will be taken from the target table.
However, it looks like we may have a bug/regression from when EasyLoader was introduced in TPT 13.0.
Please add --SourceFormat 'delimited' and that should tell EasyLoader to convert the target table schema to all-VARCHAR.
Well, I could have edited the previous comment but did not in case someone read the old one.
I checked with the developer to make sure no regressions have occurred and I was assured no regressions have been introduced.
When EasyLoader was first released with TPT 13.0, the idea was to facilitate the loading of data from a delimited flat file to Teradata without the need for a script. And the rule was that the data in the file had to match the table layout exactly (column for column). Thus, EasyLoader would take the schema from the target table and convert the non-VARCHAR columns to VARCHAR and thus generate an all-VARCHAR schema.
EasyLoader should still work that way.
Thus, I will investigate.
Ok, another update. Yes we have a regression. We were doing an EasyLoader overhaul and introduced a bug (that is currently being fixed).
If you add --SourceFormat delimited (I do not remember whether you need quotes around it), that should get around the bug.
You're best Steve! Once again you came through and I'm so appreciative! Teradata is lucky to have you and thank you for sticking with this through until the end and providing us with excellent guidance as usual.
Is it perhaps a different keyword?