All Forums Database
KVB 124 posts Joined 09/12
17 Oct 2013
Adhoc request

Hi
 I have a doubt regarding the following things in Teradata.If I have a particular table then how am i going to find the below things.Do we require a special privilege to look after these or we can achieve using any data dictionary objects?
Who all are accessing the table / view
How frequent they are accessing
Which columns
What is the source for the data
How frequent is the data loaded
What is total volume of the data in the table
What tables are populated from this? (How many level should we go up?) maybe one level up..?
Could anyone please help me in this regard?

Adharssh 36 posts Joined 08/13
17 Oct 2013

Hi,
 
You can get these things,

sel * from dbc.DBQLSqlTbl where SQLTEXTINFO LIKE '%TABLENAME%' -- To get the Queries used against the Table

SEL * FROM DBC.TABLES WHERE TABLENAME=<<TABLENAME>>; - To get the Table Definition.

sel * from dbc.TableSize where tablename='<<TABLENAME>>'; -- To get the Table Size

Thanks & Regards,
Adharssh Hospet Srinivasa Rao.

Share the Knowledge. Feel the Happiness, When you share/Teach it.

You must sign in to leave a comment.