Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 02 Jan 2004 @ 14:31:48 GMT

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

Subj:   Re: Base Tables in the View
From:   Judge, James A

That association does not exist in the standard Teradata dictionary tables. By "standard" I mean DBC tables that are populated WITHOUT any other Teradata features enabled. I'm thinking that the Qlog (query log) tables of R5 would have this information (but haven't verified at the moment). Also, if you enable the MDS (Metadata Services) schema of Teradata and run the administrative function to populate those metadata tables from the "standard" Teradata dictionary tables you could find that relationship in one of the metadata tables. Also, if you use the "query capture" (Visual Explain - QCD schema) facility, I'm pretty sure that relationship is captured in that schema as well (but not as obvious as the metadata schema - nor have I positively verified this either).

  <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: 28 Jun 2020