DSXchange: DataStage and IBM Websphere Data Integration Forum
Search found 1013 matches
Author Message
Resolved
 Topic: Server Routine causing Exception Handler to trigger
Mike

Replies: 3
Views: 425

PostForum: General   Posted: Wed Jan 03, 2018 1:43 pm   Subject: Server Routine causing Exception Handler to trigger
A routine activity must return 0 (reply=0) or it will trigger the exception handler.

I suggest calling your routine from a user variable.

A routine that returns anything besides zero requires a ...
Resolved
 Topic: How to solve below scenario using loop in tfm or otherway
Mike

Replies: 4
Views: 573

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Fri Dec 29, 2017 1:18 pm   Subject: How to solve below scenario using loop in tfm or otherway
I don't see any need for transformer looping. It looks to me like you can do everything with stage variables and output constraints.

Mike
 Topic: Comparison logic not working
Mike

Replies: 3
Views: 676

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Thu Nov 30, 2017 11:18 am   Subject: Comparison logic not working
If by CDC you mean the Change Capture stage, then be aware that it requires unique keys on both input links. You can see the result you describe when there are duplicate keys.

Mike
Resolved
 Topic: Passing and Calulating Expression Dynamically
Mike

Replies: 5
Views: 913

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: 913

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: 7
Views: 1288

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: 1636

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: 2352

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: 2352

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 ...
Resolved
 Topic: waitForWriteSignal(): Premature EOF on node
Mike

Replies: 9
Views: 2081

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: 2175

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: 2175

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: 2175

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: 2175

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: 1497

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
 

 Jump to:   



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