DSXchange

I had intended to say that the field has the length and type as Decimal 8 in both ODBC and Teradata.But somehow it is displayed as a smilie.Appologize for the inconvinience.

Hi, I am extracting data from teradata database using ODBC stage.One field is specified as Decimal (8) in the ODBC and the same field has the Metadata in Teradata as the same Decimal (8). But when I do a view data on the ODBC stage,it gives an error saying Metadata Mismatch Expected=8 Actual=18.I ca...

Hi, I am extracting data from Oracle 8i using OraOCI8.Then after making some transformations,I do a lookup for dimension keys in the corresponding HashFiles.After that I am Aggregating the Data using an Aggregator Stage. The total number of rows extracted from source is around 9000000.While aggregat...

Hi all, I have to extract top 10 sales man (in terms of number of units they have sold) and bottom 10 sales man.The data is coming through a comma separated flat file. Can I get the top and bottom 10 sales man from this data file without putting the data into any temporary table???Please suggest.

Hi all, I have to extract top 10 sales man (in terms of number of units they have sold) and bottom 10 sales man.The data is coming through a comma separated flat file. Can I get the top and bottom 10 sales man from this data file without putting the data into any temporary table???Please suggest.

I agree with you Sarvanan.You are correct.This problem comes when any of the file has no records.I had faced the same issue.If both the files have records then this issue never comes up. Hi, Make sure the both sequential files have records. I encountered the same problem if any one of the file does ...