Re: How to send data normalize data to denormalize in Teradata database
There really isn't a generalized way to do this. It depends entirely on your source and target data model. You'll need to identify which data elements are being split out into their own normalized structures, determine the key of that new structure, and write a BTEQ script that will extract from the denorm structure and insert into the various 3NF structures. This will probably require multiple passes through each source table (one for each target, at least).
One thing to consider if you're using 3NF is surrogate keys. If you're using SKs, you need to define a clear and repeatable process to maintain them. This gets tricky in BTEQ because most other ETL tools (Data Services, DataStage, Informatica, etc.) have routines that do this automatically. For BTEQ, you have to "roll your own", so to speak. Make sure it's a robust process or you'll end up with duplicate natural keys or re-using surrogate IDs down the line.