DSXchange

Hi, I have a Teradata fast export script that exports a table to a txt file. I am having problem to load this text format file into a dataset. This dataset is needed for certain lookups. The process that creates the dataset is rejecting some records saying that Delimiter for field not found. Any thoughts on how to load the data set without rejecting records.

Thanks.

Can you ensure that Null in the table does have a reprentation in the text file too(as at least empty string)?

Better output the rejected records from Sequentila File Stage to an another file and see that unfit.

Got it, It was the FastExport problem. I found a fix from Teradata for this "Two byte" issue. DataStage job is working fine

Thanks for your help.