Archives of the TeradataForum
Message Posted: Wed, 24 Oct 2001 @ 15:53:21 GMT
| 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!
Hope this helped.