Loading "N" Number of table of different structure (MYSQL) in to "N' number of Table (Teradata)Using single Script
Our Requirement is We have 'N' number of source table(MySQL) having different structure need to load to teradata Table using one script but If source and target structure changes (Column added or deleted) then Script should not change, for that they have given configuration table/file which contain information like source table name ,target table name and column to be excluded.Lets take a e.g if employee table has columns emp no,emp name,emp address and configuration table contain column to be excluded as emp address then we need to load emp no,emp name in to teradata using one script.one script should work for all different structure tables.Can we achieve this using Teradata Utility? Reply will be appreciated.
department_MySQL (dept name,dept id,manager )
Config(Source Table (Empolyee_MySQL),Target Table (Empolyee_Teradata),Address (need to exclude))