Search found 1015 matches
- Mon Sep 02, 2019 10:50 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Sort Stage - (Don't Sort) Performance Impact
- Replies: 5
- Views: 5672
I think I would go with 1 sort stage. Partition by A Sort by A,B,C,D,E LastRowInGroup(C) transformer function will give you key breaks on A,B,C LastRowInGroup(A) transformer function will give you key break on A Partition by A since you likely want all of the A rows passing through the same processi...
- Tue Mar 19, 2019 4:08 am
- Forum: General
- Topic: Creating packages for objects with istool
- Replies: 7
- Views: 17018
- Fri Mar 15, 2019 1:39 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Value for parameter could not be read using default value
- Replies: 2
- Views: 4881
I think you are a bit confused on how parameter sets and their values files are stored on the engine server. Your job design may be updating a file called param.txt, but I'll wager it is not the parameter set values file that you are updating. On the server go to your project folder. In it you shoul...
- Thu Feb 07, 2019 7:47 am
- Forum: General
- Topic: Need to get Object list from Package (.pkg) file
- Replies: 6
- Views: 5543
Totally unsupported hack... But the .pkg package file actually contains an XML document for the build manifest. In case you care to pursue using that build manifest... The .pkg file is simply a compressed archive file. You can rename it as a .zip and uncompress it. You'll see something like Manifest...
- Tue Jul 03, 2018 3:32 pm
- Forum: Cognos (IBM BI)
- Topic: Set Parameter Value with Data Item
- Replies: 5
- Views: 19085
- Mon Jul 02, 2018 4:45 pm
- Forum: General
- Topic: Best way to handle password parameters
- Replies: 9
- Views: 6881
As UCDI says, you can't prevent someone with the DataStage Developer role from hacking your passwords. In a project where there is no DataStage Developer role allowed (i.e. you can't create and compile jobs) and you also prevent read access to the DSParams file on the server (i.e. you can't copy the...
- Mon Jul 02, 2018 4:26 pm
- Forum: Cognos (IBM BI)
- Topic: Set Parameter Value with Data Item
- Replies: 5
- Views: 19085
A job can not modify its own parameters. They are set when the job begins executing. The usual technique is to use a separate job/routine/command to derive the required parameters and then pass them to the job that needs them. There should be lots of discussion about the various techniques. Since yo...
- Fri Jun 08, 2018 4:23 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Duplicate Key values in CDC Stage
- Replies: 7
- Views: 6751
I'm not sure if this is documented or if it is just something I know from experience. The change capture stage requires unique keys on its inputs. This makes perfect sense if you think about the classic two file match logic that probably happens under the covers where a key match results in the next...
- Wed Jan 03, 2018 1:43 pm
- Forum: General
- Topic: Server Routine causing Exception Handler to trigger
- Replies: 3
- Views: 3744
- Fri Dec 29, 2017 1:18 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to solve below scenario using loop in tfm or otherway
- Replies: 4
- Views: 4048
- Thu Nov 30, 2017 11:18 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Comparison logic not working
- Replies: 3
- Views: 14643
- Wed Sep 13, 2017 3:27 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Passing and Calulating Expression Dynamically
- Replies: 5
- Views: 6014
- Wed Sep 13, 2017 7:53 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Passing and Calulating Expression Dynamically
- Replies: 5
- Views: 6014
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't change often, you could handle the variable logic with a bunch of nested IF-THEN-ELSE. If you want m...
- Wed Sep 13, 2017 6:48 am
- Forum: General
- Topic: Challange in using dsjob -linkinfo feature
- Replies: 7
- Views: 6286
- Tue Sep 12, 2017 4:21 pm
- Forum: General
- Topic: ETL Job rowcount and other details
- Replies: 8
- Views: 7206