Search found 26 matches
- Thu Jun 18, 2020 9:52 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Cannot delete file and Change refresh interval
- Replies: 2
- Views: 12236
Cannot delete file and Change refresh interval
Two different questions combined here 1. There are four parallel jobs in a folder and I am trying to delete from the designer and it throws following error Error message: Unable to delete the item(s). Delete object for '\folder1\folder2\myJob' failed. Cannot find job myJob 2. How to change the refre...
- Tue Feb 25, 2020 7:34 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Generic Stage in FastTrack generated job
- Replies: 5
- Views: 7098
- Wed Feb 12, 2020 7:31 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Generic Stage in FastTrack generated job
- Replies: 5
- Views: 7098
Thank you for the response. That is what I ended up doing. The only issue is that it breaks the mapping in the copy stage which was already taken care in the generic stage. The mapping breaks because the column names in target is different from source columns due to the naming standards. Auto match ...
- Sun Feb 02, 2020 1:19 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Generic Stage in FastTrack generated job
- Replies: 5
- Views: 7098
- Sun Feb 02, 2020 8:25 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Generic Stage in FastTrack generated job
- Replies: 5
- Views: 7098
Generic Stage in FastTrack generated job
There is job that I generated from Fasttrack. The job doesn't have much transformers except for few (4) lookups from dimension tables. The job that is generated looks as follows and seem like will save time and manual work. Src Tbl > LookupContainer001 > Transformer > MappingContainer > Target Looku...
- Wed Oct 31, 2018 1:11 pm
- Forum: General
- Topic: Export failed
- Replies: 1
- Views: 2397
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 import, I cannot open 11.7 client now. Something is happening to 11.7 client once the FT assets are bro...
- Wed Oct 31, 2018 10:11 am
- Forum: General
- Topic: Export failed
- Replies: 1
- Views: 2397
Export failed
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 to other clients such as director, designer etc So I tried to export fasttrack asset using ISTOOL and I g...
- Sun Oct 21, 2018 11:23 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Lineage Report
- Replies: 2
- Views: 3462
Lineage Report
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 reads data from tab b does a bunch of lookups and pass the data through tx stage before loading into ...
- Mon Aug 27, 2018 10:15 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Parallel aggregator
- Replies: 10
- Views: 4921
- Mon Aug 27, 2018 10:41 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Parallel aggregator
- Replies: 10
- Views: 4921
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 enabled (with default rowid range). The group is performed on Year(kind of redundant because we only p...
- Tue Aug 21, 2018 1:58 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Parallel aggregator
- Replies: 10
- Views: 4921
- Mon Aug 20, 2018 5:14 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Parallel aggregator
- Replies: 10
- Views: 4921
Parallel aggregator
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 the rows out, it waits for all the input rows to be read. Is there a way to make aggregator stage p...
- Thu May 31, 2018 10:34 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: performance data
- Replies: 4
- Views: 3483
- Thu May 31, 2018 12:47 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: performance data
- Replies: 4
- Views: 3483
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 each stages and (nodes?) in the job. I would like to enable the report for the few jobs that resource...
- Thu May 31, 2018 12:17 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: performance data
- Replies: 4
- Views: 3483
performance data
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, under the job properties/Execution tab added the following line under Advanced runtime options: -padd ...