DSXchange: DataStage and IBM Websphere Data Integration Forum
Search found 207 matches
Author Message
Resolved
 Topic: Balance Optimization fails
mouthou

Replies: 5
Views: 697

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu May 23, 2019 1:38 pm   Subject: Balance Optimization fails
Ofcourse if you want Optimize suggestion from DS, yours is the way. Just so you know, have you thought of doing the sorting and duplicate removals in source Teradata SQL itself if you have the liberty ...
 Topic: NLS issues in DataStage with WIN-1252 characters
mouthou

Replies: 3
Views: 559

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu May 23, 2019 12:43 pm   Subject: Re: NLS issues in DataStage with WIN-1252 characters
As mentioned earlier, this is a multiple iteration process till the compatible character encoding is known, unless someone responded who exactly worked on the very same encoding. I had similar situati ...
 Topic: NLS issues in DataStage with WIN-1252 characters
mouthou

Replies: 3
Views: 559

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed May 22, 2019 2:55 pm   Subject: Re: NLS issues in DataStage with WIN-1252 characters
Couple of things wanted to mention:

1. You changed the DB stage setting to have required NLS. I think it should be changed at the job level to try, rather at a single stage level. Try storing sampl ...
 Topic: Need help in creating transposed file
mouthou

Replies: 11
Views: 1159

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed May 22, 2019 1:49 pm   Subject: Re: Need help in creating transposed file
Yes you could write such IF-THEN-ELSE logic with looping but when to come to think of it, it feels strongly that DS wouldnt support 5000 columns metadata and it includes my previous MODIFY stage optio ...
Resolved
 Topic: job compilation and connector issue on newly added server
mouthou

Replies: 6
Views: 862

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed May 22, 2019 1:33 pm   Subject: job compilation and connector issue on newly added server
While you are connecting with IBM support as per Paul suggestion, there is one verification you can perform among the exported/imported environment variables as in #3.

There are some APT variables ...
Resolved
 Topic: Remove Carriage Return in Sequential Stage Filter
mouthou

Replies: 10
Views: 1207

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed May 22, 2019 1:18 pm   Subject: Remove Carriage Return in Sequential Stage Filter
Just so you know. I don't think any of the response above gave a slight reference of using a Sequence as such. Those direct options were such that you could either put in ExecSH section as Ray mentio ...
 Topic: Sending an Excel Sheet to Amazon S3
mouthou

Replies: 5
Views: 614

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Sun May 19, 2019 4:09 pm   Subject: Re: Sending an Excel Sheet to Amazon S3
Just a rhetorical thought for a worst case scenario considering the columns of one tab is overwritten by other tab.

Is there a way to separate those 2 tabs and process them separately and then send ...
Resolved
 Topic: Remove Carriage Return in Sequential Stage Filter
mouthou

Replies: 10
Views: 1207

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed May 15, 2019 12:12 pm   Subject: Remove Carriage Return in Sequential Stage Filter
Any particular reason to go for a routine for CR removal? What is the issue in using unix in removing CRs and that too in the same place where header and trailer are handled.

Wondering what is mad ...
 Topic: Need help in creating transposed file
mouthou

Replies: 11
Views: 1159

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue May 14, 2019 3:19 pm   Subject: Re: Need help in creating transposed file
This certainly a challenging scenario which is almost a pivoting scenario. I think this can be done in 2 steps for 2 needs in your result. one need is to create header row with key columns and new col ...
 Topic: Field length more than 8000
mouthou

Replies: 3
Views: 595

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue May 14, 2019 2:24 pm   Subject: Field length more than 8000
You positioned a question such that it is about exceeding the length of string data types (MAX is 8000 as we see).

As Craig mentioned and as you know, your choice of data type in DS is usually base ...
 Topic: NEED LOGIC IN DATASTGE
mouthou

Replies: 2
Views: 595

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon May 13, 2019 1:17 pm   Subject: Re: NEED LOGIC IN DATASTGE
Transformer Looping is an apt choice for this scenario since there is no other direct feature in DS which helps with the result. But if you want to explore the option on the DB side, you could try LEA ...
 Topic: Converting column data into Columns and performing count
mouthou

Replies: 3
Views: 575

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon May 13, 2019 12:42 pm   Subject: Re: Converting column data into Columns and performing count
If you have a Transformer already in the job, you could use that with LOOPING logic inside the Transformer itself and get the count directly for each JobId (if you find Aggregator and Pivoting combina ...
 Topic: Throwing exception: APT_BadAlloc: Heap allocation failed.
mouthou

Replies: 7
Views: 1300

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon May 13, 2019 12:03 pm   Subject: Re: Throwing exception: APT_BadAlloc: Heap allocation failed
Heap allocation is a generic error related to buffering and memory allocation. Not much direct answer for this error as the job needs to be completely checked. But to begin with, are you getting this ...
Resolved
 Topic: Remove Carriage Return in Sequential Stage Filter
mouthou

Replies: 10
Views: 1207

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Sun May 12, 2019 4:15 pm   Subject: Re: Remove Carriage Return in Sequential Stage Filter
Based on Craig's and Ray's response focusing on carriage returns, I am slightly confused of your need. I think you are looking for a command pattern which does both header/trailer removal and CR remov ...
Workaround Reported
 Topic: Trying to extract row with certain criteria
mouthou

Replies: 2
Views: 511

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Apr 22, 2019 12:20 pm   Subject: Trying to extract row with certain criteria
Transformer stage is an option for this scenario and it should work with your constraint. I suspect the format of the input values coming for 'STAT CODE' is not correctly compared.

- Can you can c ...
 

 Jump to:   



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