DSXchange

Yeah,for the volume of input data to extract,modular design is suitable.but how do we go about checking if the extraction is empty.Taking a count of the table is not appropriate looking at the huge volume of data.Is there any other alternative?

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?

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?

Which Teradata Stage is more efficient when there is huge input data for extraction?Input volume:approximately 450 million recs. which Teradata stage (Enterprise or API) helps extraction of data more efficiently? Also after extraction from any of the above is done,i need to check if the extraction r...