DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
Author Message
jackson.eyton



Group memberships:
Premium Members

Joined: 26 Oct 2017
Posts: 143

Points: 2340

Post Posted: Wed Jul 01, 2020 1:26 pm Reply with quote    Back to top    

DataStage® Release: 11x
Job Type: Parallel
OS: Windows
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:

Quote:
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
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours