I am migrating an Oracle DW to Teradata.
I need to load the same 40 files that are currently loaded. I have their SQL*Loader control files.
Is there a tool, or a script, that will convert these CTL files to a Teradata script for any of the loading tools (TPT, FastLoad etc')?
I have never heard of any tool that converts sql loader control files to teradata scripts. You can replicate ctl files functionalities using tpt or fastload . Even if a tool exists also for converting- for complex ctl files like changing data during upload, bad reject handling, complex sql functions etc, I doubt it brings good results. The features and syntax of SQL Loader utility are different.There maybe issues. If they are not complex ones, then probably no issues.
I dont think there exists any tool/script .... even if it does am sure writing 40 Fastload/TPT scripts would be much faster as commpared to converting, testing, finding issues and then re-doing scripts.