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.
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.