I’m new to Teradata and new this forum... We have EDW running at the moment in DB2 and we're going to Teradata now.
DB2 has 1000 tables in EDW.
My question is....
Are there any tool or utilities to convert the DB2 DDL scripts (1000 tables) into Teradata env..
Please help us and let me know any document ion also.
Do you have ERWIN? You can import the DB2 table DDLs using reverse engineering and then can export in Teradata DDLs. I haven't tried it myself but its worth giving a try...