DSXchange: DataStage and IBM Websphere Data Integration Forum
Search found 21 matches
Author Message
 Topic: Export failed
perspicax

Replies: 1
Views: 377

PostForum: General   Posted: Wed Oct 31, 2018 1:11 pm   Subject: Export failed
Update

I had another etl server with 11.7. Fast track client opened initially. I imported the fasttrack export of 11.5 ( which was also imported in the other 11.7 server before upgrade). After the ...
 Topic: Export failed
perspicax

Replies: 1
Views: 377

PostForum: General   Posted: Wed Oct 31, 2018 10:11 am   Subject: Export failed
DataStage® Release: 11x
Job Type: Parallel
OS: Unix
Additional info: 11.7
We upgraded one of the etl server from 11.5 to 11.7. Since then we are not able to connect to fasttrack client. We get the following error:

Server Registration failed.

But we are able to connect ...
Resolved
 Topic: Lineage Report
perspicax

Replies: 2
Views: 598

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Sun Oct 21, 2018 11:23 pm   Subject: Lineage Report
DataStage® Release: 11x
Job Type: Parallel
OS: Unix
Trying to create a lineage report. I have two jobs, job1 loads data from tab a to tab b (kind of staging job which is 1 to 1. Then job 2 which takes the data from tab b and loads into tabc. This job r ...
 Topic: Parallel aggregator
perspicax

Replies: 10
Views: 795

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Aug 27, 2018 10:15 pm   Subject: Parallel aggregator
The transformer is set to auto. So if 'hash' or 'modulus' is selected in Agg stage then the same partition type should be set in the transformer? I will change the settings and report back.

Thanks
 Topic: Parallel aggregator
perspicax

Replies: 10
Views: 795

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Aug 27, 2018 10:41 am   Subject: Parallel aggregator
Yes the job is executing on 6 nodes with all the stages running on the same nodes. In this eg, the upstream stage is a transformer stage. The input stage is a Oracle stage where partitioned read is en ...
 Topic: Parallel aggregator
perspicax

Replies: 10
Views: 795

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Aug 21, 2018 1:58 pm   Subject: Parallel aggregator
Thanks. It worked. Earlier, the sort order was different than order of group key column. I selected partition type 'Same'. I am not sure what it means. 'Auto' and 'Entire' didn't work. What is the rec ...
 Topic: Parallel aggregator
perspicax

Replies: 10
Views: 795

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Aug 20, 2018 5:14 pm   Subject: Parallel aggregator
DataStage® Release: 11x
Job Type: Parallel
OS: Unix
Is pipe-lining possible when aggregator stage is used. For instance, I have a job using aggregator, that sums up colD by grouping 3 input columns, ColA, ColB, ColC, so before aggregator start spitting ...
 Topic: performance data
perspicax

Replies: 4
Views: 721

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu May 31, 2018 10:34 pm   Subject: performance data
I figured this out. I was following IBM KB which was not correct for enabling this at the project level. It worked after I set the value (path) $APT variable and specifying this in the job

Will ena ...
 Topic: performance data
perspicax

Replies: 4
Views: 721

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu May 31, 2018 12:47 pm   Subject: performance data
I am new to DS. I do not know how to use it. I bumped into this tool within director which seems to have a set predefined reports on the data it collects in a directory indicating the performance of e ...
 Topic: performance data
perspicax

Replies: 4
Views: 721

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu May 31, 2018 12:17 pm   Subject: performance data
DataStage® Release: 11x
Job Type: Parallel
OS: Unix
I wanted to enable record performance data to view the performance data as a graph using the tool in director. To do this I went to DS designer client, opened the job I wanted to collect the stats, u ...
Resolved
 Topic: set default value on look up failure
perspicax

Replies: 4
Views: 675

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Fri May 18, 2018 12:41 pm   Subject: set default value on look up failure
It works! I was using isnull vs ISNULL to handle and I think it is case sensitive.

In the hash file look up there is a function called NOTFOUND. Is this not relevant in parallel jobs?

Thanks!
Resolved
 Topic: set default value on look up failure
perspicax

Replies: 4
Views: 675

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed May 16, 2018 3:30 pm   Subject: set default value on look up failure
DataStage® Release: 11x
Job Type: Parallel
OS: Unix
I have set the lookup stage conditions to 'continue' on lookup failure. These lookups are surrogate key lookup. It's defaulting to 0 for these values. Is there a way to default to a different value, l ...
Resolved
 Topic: Convert space to null
perspicax

Replies: 8
Views: 974

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed May 16, 2018 1:20 pm   Subject: Convert space to null
I used setnull() and it works. I think @NULL works only in server jobs.

Maybe this is for another topic, I only see 5-6 system variables in parallel job while using transformer. Is there any settin ...
Resolved
 Topic: Convert space to null
perspicax

Replies: 8
Views: 974

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed May 16, 2018 12:34 pm   Subject: Convert space to null
Also it says @NULL not defined. I do not see @NULL defined under system variable
Resolved
 Topic: Convert space to null
perspicax

Replies: 8
Views: 974

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed May 16, 2018 12:33 pm   Subject: Convert space to null
The if expression is not evaluating to true. It is not inserting even "NULL" instead it's inserting 0
 

 Jump to:   



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