Search found 5 matches

by LS
Tue Mar 15, 2011 5:55 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Issue with Surrogate Key generator stage in 8.1 PX version
Replies: 2
Views: 2459

Re: Issue with Surrogate Key generator stage in 8.1 PX versi

Hi krishna.m.

Are you running a 64bit machine? Also check your compiler options...

Have fun,
me.

[snip]
by LS
Tue Mar 15, 2011 5:39 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: how can i get the received file timestamp in datastage
Replies: 2
Views: 2687

Re: how can i get the received file timestamp in datastage

Hi hemanthakumar. If I understand you want the OS file timestamp of the files. You can use the External Source stage and issue the command: ls -lisa your_directory Configure this stage with one column like varchar(200) and then pick up the portion where you have the date and time to build the timest...
by LS
Tue Mar 15, 2011 5:18 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Calculating subtotals
Replies: 4
Views: 3632

Re: Calculating subtotals

Hi AngelMady. Yes I can. I am assuming that the only column you want sorted in the output is the id. Job: File -> Sort -> Transformer -> Sort -> Transformer -> File 1. Read you file and hash by id, so all ids with same value are on the same partition. 2. Sort by id. 3. Add a transformer and with the...
by LS
Tue Mar 15, 2011 4:30 pm
Forum: General
Topic: Parameter Sets - Password Maintenance by Support Staff
Replies: 3
Views: 6133

Re: Parameter Sets - Password Maintenance by Support Staff

Hi AGStatfford. I can remember several ways to do it nice. One way is to make a dummy job that accepts that password. Ask the DBA's to run that job (they will input password). Build a script that can be called by this dummy job on the "after section" that reads the log. On the log you will...
by LS
Tue Mar 15, 2011 4:16 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Trying to understand job score (1)
Replies: 11
Views: 8847

Re: Trying to understand job score (1)

Hi abc123. 1: You can check what are the virtual datasets by looking at what d0, d1, d2 and d3 are. The job score explains exactly why the 4 datasets. 2: eAny means round robin partitioner; eCollectAny means round robin collector; "=>" means parallel to parallel - same. 3: In this case yes...