Search found 5168 matches

by kumar_s
Sun Jun 30, 2019 3:59 pm
Forum: General
Topic: Sequential(CSV) file structure validation?
Replies: 5
Views: 5873

I have done the Craig's suggestion in my past. Especially the top 2.
Compare the header of the incoming file against the predefined list. And.. thats it.
Assumption is that, header would promptly represent the all Data column and its values.
by kumar_s
Tue Apr 09, 2019 9:09 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Heap growth during runLocally()and production run time debug
Replies: 11
Views: 9111

With more partition, you startup time and production time is increasing. Are you still running with the Auto partition as you mentioned in your original job design (the first post)? Or using specific partition as you mentioned in later post? If not done, my suggestion is to Partition the data at ear...
by kumar_s
Tue Apr 09, 2019 12:05 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Factors to decide the run mode of Oracle connector
Replies: 5
Views: 4248

Perhaps Datastage undergoing overhead based on Partition read method.
Partitioned read works well for the Partitioned data.
Have you tried the Rowid round robin method?
Ideally this should do a simple partitioning.
by kumar_s
Tue Mar 13, 2018 5:14 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: ODBC Connector issue
Replies: 7
Views: 5271

If the duplicates are getting loaded only one (only during the second run), did you check for any whitespace or PADCHAR on the key field?
by kumar_s
Mon Mar 12, 2018 11:52 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: double quotes in data
Replies: 3
Views: 3097

You do not have double qoute in all fields.
Have the quote character as None and import the data.
by kumar_s
Wed Jul 27, 2016 3:56 pm
Forum: General
Topic: Fallen Premium Poster: Kim Duke
Replies: 32
Views: 26014

:( Cant believe that Kim is no more with us. May his soul RIP!
by kumar_s
Wed Dec 23, 2015 3:02 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Data Type Conversion - Ora to NZ - Using RCP
Replies: 3
Views: 5806

One options, that strikes my mind is to create the table prior to loading. And just 'Insert' the record.
While creating the table, convert those Numeric fields to integer.
by kumar_s
Wed Dec 23, 2015 2:47 pm
Forum: General
Topic: DSX export progress intermittently very slow to start
Replies: 14
Views: 9008

If this happens from various client machine, Could be possible that the temp folders are full or almost full.
Try clearing those, and along with it, do the clean up of COMO and PH folders.
Its also worth doing a reindex of the project. Make sure you follow the steps in doing it.
by kumar_s
Sun Nov 08, 2015 9:13 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Failed to distribute component
Replies: 3
Views: 4101

Thanks for the Hits. Looks like IBM has workaround for any thing!! QualityStage has introduced an environment variable QSM_DISABLE_DISTRIBUTE_COMPONENT to turn off the distribute-component call when the project folder is shared by all compute nodes. set this environment variable to 1/true in this jo...
by kumar_s
Sat Nov 07, 2015 11:20 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Failed to distribute component
Replies: 3
Views: 4101

Failed to distribute component

Its just couple of years short to meet a decade with this post :) Unfortunately, the OP has marked the post as Resolved without posting the solution. Iam getting the same Error with a Data Quality Standardize sage. Failed to distribute component "/Project/USADDR.SET" to node "Node1&qu...
by kumar_s
Tue Nov 18, 2014 5:32 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Leading Zero in RCP Job
Replies: 14
Views: 14627

Why is the interger read as Numeric?
Integer in Oracle could be Numeric in Datastage.
But covert it to interger in Datastage to get rid of padded zeros.
by kumar_s
Tue Nov 18, 2014 5:28 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: TIME CONVERSION
Replies: 12
Views: 9981

You can use StringToTime as well. With just %nn:%ss to map it to a time field.
But you ll need a padding of zero anyway.
by kumar_s
Wed Feb 08, 2012 4:07 pm
Forum: General
Topic: Starting a job from PC
Replies: 6
Views: 4131

Probably yes.
What is the full error message?
by kumar_s
Wed Feb 08, 2012 4:02 pm
Forum: General
Topic: How Do I Find a DataStage Program Within A Project?
Replies: 1
Views: 2577

In Director, you have option to remove the Category view.
i.e., all job in one page. Find works perfectly then.

Or just issue "LIST DS_JOBS {jobname}" in TCL prompt.
by kumar_s
Wed Feb 08, 2012 4:00 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Lookup value 0
Replies: 9
Views: 6079

Is there any auto conversion into Integer?
Try to make sime dataytpe at both input and reference. Try converting the Char into Varchar.