DSXchange: DataStage and IBM Websphere Data Integration Forum
Search found 1010 matches
Author Message
Resolved
 Topic: Passing and Calulating Expression Dynamically
Mike

Replies: 5
Views: 172

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Sep 13, 2017 3:27 pm   Subject: Passing and Calulating Expression Dynamically
Bunch of nested if-then-else:

If Client = "A" Then Client A logic
Else If Client = "B" Then Client B logic
Else If Client = "C" Then Client C logic
...

Not at all flexible since you will have ...
Resolved
 Topic: Passing and Calulating Expression Dynamically
Mike

Replies: 5
Views: 172

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Sep 13, 2017 7:53 am   Subject: Passing and Calulating Expression Dynamically
The transformer stage doesn't support dynamic derivation expressions. The design-time derivation expression is compiled into the executable code.

If you have a reasonable number of clients that won ...
 Topic: Challange in using dsjob -linkinfo feature
Mike

Replies: 6
Views: 138

PostForum: General   Posted: Wed Sep 13, 2017 6:48 am   Subject: Challange in using dsjob -linkinfo feature
DSODB is way too valuable a resource to be locked away. All developers should have read access. Take it up with your admin folks.

Mike
 Topic: ETL Job rowcount and other details
Mike

Replies: 8
Views: 179

PostForum: General   Posted: Tue Sep 12, 2017 4:21 pm   Subject: ETL Job rowcount and other details
Why reinvent a redundant wheel? Everything you need is already available in DSODB.

Mike
 Topic: Unicode with RCP?
Mike

Replies: 11
Views: 264

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Sep 11, 2017 4:26 pm   Subject: Unicode with RCP?
You could experiment with the NLS Code page at the job and stage levels. See if UTF-16 will help.

Mike
 Topic: Unicode with RCP?
Mike

Replies: 11
Views: 264

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Sep 11, 2017 11:27 am   Subject: Unicode with RCP?
RCP isn't going to do any type conversion. If your source is a ustring then it will propagate as a ustring. If it is a string then it will propagate as a string.

If you need to convert between ustr ...
 Topic: waitForWriteSignal(): Premature EOF on node
Mike

Replies: 8
Views: 496

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Aug 07, 2017 6:26 pm   Subject: waitForWriteSignal(): Premature EOF on node
You've told the aggregator to expect sorted data. So have you partitioned and sorted the data by the keys that the aggregator is using? Have you set up your funnel stage to preserve the sort order if ...
 Topic: Update SK Files with last surrogate Key values
Mike

Replies: 9
Views: 571

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Fri Jun 30, 2017 2:33 pm   Subject: Update SK Files with last surrogate Key values
Can't really say what your issue might be without actually looking over your shoulder. But in your example, the originally updated 16 byte surrogate key file should show
2004 2004 when viewed with th ...
 Topic: Update SK Files with last surrogate Key values
Mike

Replies: 9
Views: 571

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Fri Jun 30, 2017 9:30 am   Subject: Update SK Files with last surrogate Key values
The Surrogate Key Generator stage results in a sequential operator, so the number of processing nodes shouldn't matter. Partitioning is not needed or wanted.

I still use my default parallel configu ...
 Topic: Update SK Files with last surrogate Key values
Mike

Replies: 9
Views: 571

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Fri Jun 30, 2017 9:21 am   Subject: Update SK Files with last surrogate Key values
Then you did not successfully start with an empty state file.

It will have a length of 0 when it is empty. After your update it should have a length of 16.

Use an ls -l mystatefile to check file ...
 Topic: Update SK Files with last surrogate Key values
Mike

Replies: 9
Views: 571

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Fri Jun 30, 2017 7:41 am   Subject: Update SK Files with last surrogate Key values
There are quite a few nuances to the surrogate key generator stage. It actually includes some interesting flexibility. You would have to spend some time experimenting to learn all of the nuances.

I ...
 Topic: Generate sequence number using parallel job
Mike

Replies: 6
Views: 580

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Jun 21, 2017 7:08 am   Subject: Generate sequence number using parallel job
Did you use round robin partitioning method?

Mike
 Topic: code version check
Mike

Replies: 4
Views: 421

PostForum: General   Posted: Tue Jun 20, 2017 6:45 pm   Subject: code version check
I've gone with a 2 step approach for identifying version change candidates.

Step 1 is to compare the modification timestamps using XMETA. These are the same modification timestamps that you would s ...
Resolved
 Topic: Unable to find Java Technology Edition software
Mike

Replies: 2
Views: 232

PostForum: General   Posted: Fri Jun 16, 2017 7:28 am   Subject: Unable to find Java Technology Edition software
I haven't done an 11.5 install yet, but for all other versions that I have installed the required IBM java is part of the installation package. You just have to follow the installation instructions an ...
Resolved
 Topic: Fatal Error: Attempt to setIsNull() on the accessor interfac
Mike

Replies: 13
Views: 723

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Jun 15, 2017 9:41 am   Subject: Fatal Error: Attempt to setIsNull() on the accessor interfac
Nice job of narrowing down the cause.

It's good to know that a failed cast function in the ODBC Connector results in NULL.

You mentioned AS400, so is your underlying database DB2?

Mike
 

 Jump to:   



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