Identify Trouble Column on Transform Error

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
jackson.eyton
Premium Member
Premium Member
Posts: 145
Joined: Thu Oct 26, 2017 10:43 am

Identify Trouble Column on Transform Error

Post by jackson.eyton »

Hi guys, I feel like I must be missing something here. I have some files that I am bringing in from a CSV, due to datastage's quirks we bring in all fields as VarChar initially then transform them in an TRANSFORM stage to what the intended data type should be. My biggest issue is when I have many fields and more than a handful are being transformed from string to decimal/integer. Some of the files we get are "new" and therefore not populated with much data and its our best guess right now what the data type and length should be. The vendor is absolutely no help on this one. Not my choice I just work here. The following however is what I would consider a remarkable lack on IBMs part OR a ridiculous oversight on my part that I havent been able to find the answer to as of yet. When one or more of these fields isn't defined right for the data or doesn't transform properly, datastage just says there was an issue transforming the string to decimal but fails to specify on what column. When I have 20 or more potential columns it can be insanely time consuming to try and track down. The errors I get are as follows:
Server:INFOENG1DEV
Project:dstagedev1
Job No:1417
Job name:Raw_Stage_ML_Deposits_Applicants
Invocation:
Event Number:264
Event type:Warning
User:DACOTAHBANK\dsadmin
Timestamp:7/2/2020 2:53:59 PM
Message Id:IIS-DSEE-TBLD-00008
Message:
XFM,0: Conversion error calling conversion routine decimal_from_string data may have been lost
Is there a way to track down what columns are the source of the failure?
-Me
Post Reply