Best strategy for data migration from one Teradata DB to Another Teradata DB(Different Data Model)

[ajaypratap]

Hi All,

What is the best way to migrate a warehouse from one Teradata data data base (2NF) to new DB teradata DB(3NF) with same PIs.

1) Bteq Scripts(to prepare data in new format) along with MLOAD(to load for 3-4 baselines,or FASTLOAD to load in one go)

2) GCFR Patterns

3) Insert/Select

Which of these three will be most effective method.

[GJColeman]

Nothing is faster than insert-select (or merge) into an empty table.  That would also be the easiest way if they are on the same system.  Otherwise I would try to copy the data as-is to the second system and then use merge to create the new tables.  The method for copying the data might be DSA backup-restore, or Fast Export and then Fast Load.  I think any other approach would require more coding and would not save any time.