DataStage-Teradata Query

ray.wurlod · Post by **ray.wurlod** » Wed Jun 22, 2011 3:42 am

Welcome aboard.

They're probably not white spaces but something else. Dump them into a text file then use a hex editor/viewer to determine what they actually are.

yenepalli · Post by **yenepalli** » Wed Jun 22, 2011 3:45 am

Thank You. COuld you please elaborate more on this ?

ray.wurlod · Post by **ray.wurlod** » Wed Jun 22, 2011 3:51 am

Not really. Replace your Teradata stage with a Sequential File stage then examine the records that have these characters. Alternatively create a reject link from your Teradata Connector stage and examine the records sent along that link (into a sequential file).

yenepalli · Post by **yenepalli** » Thu Jun 23, 2011 4:16 am

Thanks Ray