How to get Count of table used in a stage.

aschindler · Post by **aschindler** » Tue May 28, 2013 10:58 pm

Hi

I have a set of parallel jobs and i need to get the count(*) from table that has used in target stage of each job,that count need to be captured in a server job which will load audit table.Is there any way to get the database name and table name and to run the sql queries to get the count captured in my server job.

Please help.

ray.wurlod · Post by **ray.wurlod** » Wed May 29, 2013 12:02 am

The easiest way is to query the system tables (or "catalog" in some databases) in which the tables reside.

kduke · Post by **kduke** » Thu May 30, 2013 5:27 pm

That is what my ETL completeness does. Do a search. Just a few jobs to make it work. It is table driven. Easy to use and setup. Been using it for years. Works great.