How to send data normalize data to denormalize in Teradata database

General
Enthusiast

How to send data normalize data to denormalize in Teradata database

Hi guys,

I am new in Teradata we are going to implement to move data from denormalize to normalize in Teradata database

Can any body give with example how to do it this thing .we are going to implement write bteq script only

Please let us know if any body done this kind of work please send me sample script
1 REPLY
Enthusiast

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.