how to Identify whhich job is connecting to a specific data

A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.

Moderators: chulett, rschirm, roy

Post Reply
alexcol
Participant
Posts: 17
Joined: Mon Feb 28, 2011 8:52 am

how to Identify whhich job is connecting to a specific data

Post by alexcol »

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
ALEJO
Post Reply