Please share any possibility approach with automated process for 2500+ Teradata tables. Urgent

Database

Please share any possibility approach with automated process for 2500+ Teradata tables. Urgent

Requirement:

Need to standardize below in Teradata. After standardization, tables should have:

  1. Create TS and Update TS. Also the columns should be properly updated when an insert/update happens.
  2. All date columns should be of DATE/TIMESTAMP data type and data should be loaded properly
  3. Column naming standardization has to be done and the corresponding scripts has to be updated

Note: Above are the details given by Stanley. This may or may not be the final list

Scope:

  1. DDL changes
  2. BTEQ script changes
  3. Dev & QA testing
  4. Production Implementation

Out of Scope:

  1. Informatica changes
  2. Changes to any dependent tables/reports
2 REPLIES
Senior Apprentice

Re: Please share any possibility approach with automated process for 2500+ Teradata tables. Urgent

This will be a huge project, hopefully they pay you well.

If this is actually urgent you should try to get rid of it, it's way too late to ask right here and right now :-)

Good luck.

Teradata Employee

Re: Please share any possibility approach with automated process for 2500+ Teradata tables. Urgent

And it would be better to start at the LDM level, to ensure consistency across all tables.