Source extraction returns 0 rows

Shamitha_Shetty · Post by **Shamitha_Shetty** » Tue Aug 14, 2007 4:22 am

When source data is extracted using Teradata Enterprise stage,source volume being more than 400 million records,if the extraction returns 0 rows then processing should stop reporting a critical error .how do we check if the source extraction is empty?

DSguru2B · Post by **DSguru2B** » Tue Aug 14, 2007 4:38 pm

In a seperate job, perform a count on the table. If you get a zero, do not do anything or send out an email. If its greater than zero then you can run your current job that processes the table. You can couple these jobs and implement the process in a sequence job.

Shamitha_Shetty · Post by **Shamitha_Shetty** » Wed Aug 15, 2007 10:52 pm

Taking a count would not be a very efficient way, looking at the volume of the data.Since this kind of scenario is very rare-where the table extraction would be empty-it would happen once in a while.Is there any alternative way to do this?

ArndW · Post by **ArndW** » Wed Aug 15, 2007 11:06 pm

Add an after-job routine call that gets the row count from the TeraData selection using DSGetLinkInfo(DSJ.ME,{LinkName},DSJ.LINKROWCOUNT) and if it is 0 issue a call to DSLogFatal().

ray.wurlod · Post by **ray.wurlod** » Thu Aug 16, 2007 12:46 am

Select the first row from the table. If it's not there, there are 0 rows.