I have four excel files with 75,000 records each in them with the same data and unioned together. I want to create a temporary table from it in Teradata, but since the load it too larger, I need to create the table with a Primary Key using one of the fields that is in the excel data.
What is the correct syntax to code in the Pre-Create SQL Statement or Post Create SQL Statement for the Output Tool to achieve this?
Hello
Post create is the best way (the other way is to build a monstruosity that allows you to chose the primary key and create a script to create the table with the right primary key)