how to Identify whhich job is connecting to a specific data
Posted: Fri Jul 22, 2011 9:20 am
Im a dummy about Teradata and i have a question
in an Production system there are hundreds of process that extracts information from heterogenous and operational database system, thors are RDBS like oracle, sqlserver, sybase etc.
In Director Program graphically shows me which tables are accessing because they are named by menas of odbc stage icon but cant see which connection is used, whuch source database is using, user y password because the info is encrypted.
i've heard about Medatada engine and Metadata Services. the question is by means of teradata engine can i find out what i was lookjong for? if yes how.
Or can i make any query like a select statemente to the system tables like select * from DBC.object ?
id appreciate your help
in an Production system there are hundreds of process that extracts information from heterogenous and operational database system, thors are RDBS like oracle, sqlserver, sybase etc.
In Director Program graphically shows me which tables are accessing because they are named by menas of odbc stage icon but cant see which connection is used, whuch source database is using, user y password because the info is encrypted.
i've heard about Medatada engine and Metadata Services. the question is by means of teradata engine can i find out what i was lookjong for? if yes how.
Or can i make any query like a select statemente to the system tables like select * from DBC.object ?
id appreciate your help