How to track which ETL job is loading 1 particular DB table

chulett · Post by **chulett** » Wed Nov 29, 2006 1:04 am

Nope. Create the metadata first then use it. The act of 'loading' or dragging the metadata into the job itself is what creates the link the Usage Analysis tool needs.

ray.wurlod · Post by **ray.wurlod** » Wed Nov 29, 2006 1:37 pm

DSer wrote:Can we save the metadata definitiona at a later stage and use this method?

Yes, using Save from a job design also establishes a linkage that Usage Analysis and other analyses can use. (However it does not save format information for sequential files.)

During the Save dialog be systematic about your categories - don't simply dump everything into the Saved category!

DSer · Post by **DSer** » Wed Nov 29, 2006 10:49 pm

Thanks for the info.

So does it mean that we can get the usage analysis for jobs refering to a particular table,

before we have saved the metadata and after we have saved?

Or it it only moving forward, after the save is done?

ray.wurlod · Post by **ray.wurlod** » Wed Nov 29, 2006 11:06 pm

Before you have saved, NO.
After you have saved, YES. Even for extant jobs.

Going forward, learn to Import then Load, rather than need to Save. You will make fewer mistakes in this way.

samyamkrishna · Post by **samyamkrishna** » Fri Jan 16, 2009 1:58 am

Hi,

I have a list of inactive jobs in the project.
I want to know the tables these jobs are using.
the tables may be source or target tables.
and the tables are teradata enterprise stages.

How do i get the list of tables in the project.

Thanks,
Samyam

samyamkrishna · Post by **samyamkrishna** » Fri Jan 16, 2009 2:04 am

I tried this but this query gives a lot of details.
I need only the table name and the DB name.

select EVAL DS_JOBOBJECTS."@RECORD<29>" from DS_JOBOBJECTS where DS_JOBOBJECTS.NAME ='JxZZEXT_TYP_FACT_ENCS_DECS';

Thanks,
Samyam

ray.wurlod · Post by **ray.wurlod** » Fri Jan 16, 2009 5:25 am

I think that question is far enough from the original topic of this thread to warrant your creating a new thread for it.

samyamkrishna · Post by **samyamkrishna** » Fri Jan 16, 2009 5:54 am

I have tried everything mentioned in the thread.
its not working. so you are saying there is no way to get it.

chulett · Post by **chulett** » Fri Jan 16, 2009 8:19 am

No, he's saying to stop hijacking this thread and create one of your own instead.

kduke · Post by **kduke** » Fri Jan 16, 2009 1:21 pm

The SQL in

viewtopic.php?t=99543

Will find any string in a job. Use it and see if you cannot find all the jobs using a specific table.

DSXchange

How to track which ETL job is loading 1 particular DB table

Wnat to the table names