Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 24 Oct 2001 @ 15:53:21 GMT


     
  <Prev Next>   <<First <Prev Next> Last>>  


Subj:   Re: How does it Do it??
 
From:   John K. Wight

In the Teradata Parser there is a module called the Resolver. It is during this phase of the parsing process that any views get 'translated' down to the base tables and by the time the parser is finished and ready to submit the request (i.e. SQL) all you have is the 'raw SQL' referencing the base tables. You have no way to tie them back other than manually coming from the original view down through their references to the base tables. If you change the names of the base table attribute names (because some techy or IT standard for attribute naming that is 20 years old, wanted hieroglyphic names) to more 'user friendly names' for the end users, you have to suffer those early design decisions in your mapping!

Good Luck.


Hope this helped.



     
  <Prev Next>   <<First <Prev Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023