Source extraction returns 0 rows
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 4
- Joined: Sun Jul 15, 2007 11:59 pm
Source extraction returns 0 rows
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?
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.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
-
- Participant
- Posts: 4
- Joined: Sun Jul 15, 2007 11:59 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().
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: