How to read a fast export file thru datastage

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
Nagin
Charter Member
Charter Member
Posts: 89
Joined: Thu Jan 26, 2006 12:37 pm

How to read a fast export file thru datastage

Post by Nagin »

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.
ag_ram
Premium Member
Premium Member
Posts: 524
Joined: Wed Feb 28, 2007 3:51 am

Post by ag_ram »

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.
Nagin
Charter Member
Charter Member
Posts: 89
Joined: Thu Jan 26, 2006 12:37 pm

Re: How to read a fast export file thru datastage

Post by Nagin »

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.
Post Reply