Hi
How about trying distributed hash file using data segmentation? I hope this will be another work around.
Cheers
Pramod
Search found 30 matches
- Mon Jul 10, 2006 1:47 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Large hashed file
- Replies: 2
- Views: 1522
- Mon Jul 10, 2006 1:39 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: uvconfig - DS Tuning ?
- Replies: 2
- Views: 1980
uvconfig - DS Tuning ?
Hi, I am trying to understand how to select optimum values in uvconfig file so that different projects with different architecture can co-exist in the same server. Overview: One of project extensively uses multiple instance jobs while the other projects process huge volume of data (approx. 20 millio...
- Tue Oct 18, 2005 1:23 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Transformation Rows to columns
- Replies: 4
- Views: 2060
Transformation Rows to columns
Hi
I have the following requirement
Input Data:
a|1
a|2
b|2
b|3
Output Data
a|1,2
b|2,3
I have the following requirement
Input Data:
a|1
a|2
b|2
b|3
Output Data
a|1,2
b|2,3
- Fri Jul 29, 2005 5:53 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: merge three files
- Replies: 8
- Views: 3069
Hi Please give me a sample output of the merge file. I am not sure whether u want the merged file to look as: $ cat merge 0,data0 0,data0 0,data0 1,data1 1,data1 2,data2 $ cat file1 0,data0 1,data1 2,data2 $ cat file2 0,data0 1,data1 $ cat file3 0,data0 $ paste file1 file2 file3 > merge thanks Pramod
- Fri Jul 29, 2005 5:39 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Regarding DSJ.JOBPID
- Replies: 2
- Views: 1855
Regarding DSJ.JOBPID
Hi
jobpid= DSGetJobInfo (DSJ.ME, DSJ.JOBPID) return me "0" always.. I am not sure whether this is PID right
Can i use this jobpid to kill a job from unix ?
Thanks
jobpid= DSGetJobInfo (DSJ.ME, DSJ.JOBPID) return me "0" always.. I am not sure whether this is PID right
Can i use this jobpid to kill a job from unix ?
Thanks
- Tue Jul 26, 2005 9:47 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Weird Error Message
- Replies: 16
- Views: 8914
- Tue Jul 26, 2005 4:59 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Sequence logs
- Replies: 2
- Views: 1367
Sequence logs
Assume I have main sequence which consist of sub sequence 1 ,2,3. Each sub sequence has 5 different jobs that runs. Each jobs are stored in different categorty. I would like to know how will i get information of the summary of sequence which job under which subsequence got aborted. Is there any DS c...
- Thu Jan 06, 2005 12:40 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: running job every 1 hr
- Replies: 2
- Views: 1843
- Fri Dec 24, 2004 7:33 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Leading Zero's on Numeric Fields
- Replies: 3
- Views: 2865
Re: Leading Zero's on Numeric Fields
I am wanting ao add leading zero's to a numeric field if it is not 10 characters long. I know the FMT Function is used for string fields but what can I use for a numeric field ? Alternate Way: If LEN(NUMERIC_FIELD) < 10 then oconv(NUMERIC_FIELD,"MR%10") else NUMERIC_FIELD Hope this helps....
- Sat Nov 27, 2004 11:18 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: To run a job with job parameters...........
- Replies: 11
- Views: 28611
Re: To run a job with job parameters...........
Hi
Please Check your user id and password for DB.
If ur using ODBC stage to connect to DB, click Get SQL Info after providing the DSN, user id and password (in parameter form).
Please Check whether the parameter has been typed correctly in the stage?
#DSN#
#USERID#
#password#
Please Check your user id and password for DB.
If ur using ODBC stage to connect to DB, click Get SQL Info after providing the DSN, user id and password (in parameter form).
Please Check whether the parameter has been typed correctly in the stage?
#DSN#
#USERID#
#password#
- Sat Nov 27, 2004 10:55 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: To capture duplicate rows
- Replies: 7
- Views: 4895
Re: To capture duplicate rows
Hi Try this out Sequential File ---> Transformer1 ---------------> Aggregator ----------------> Transformer2(count >1) --- > seq with Duplicate records Transformer1 ========= Define a column called count assign value 1 to all the rows that u read from the sequential file. In the aggregrator group by...
- Wed Jul 21, 2004 5:16 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Append in a lookup fileset
- Replies: 2
- Views: 2344
Re: Append in a lookup fileset
Yes u can append a lookup file. 1. Create Hash file which reads from the input sequential file. This hash file is used as a reference. 2. Create a new job which checks for the new records against the above hash file. If the record is new, then it is inserted into the Hash file. While designing the a...
- Wed Jul 21, 2004 4:58 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Erroooooorrrrrrrrrrrr
- Replies: 1
- Views: 2252
Re: Erroooooorrrrrrrrrrrr
Hi Where do u get this error? Please elucidate. Thanks Pramod Hi everyone, can you help me for this bad error? main_program: Accept timed out retries = 56 Accept timed out retries = 55 Accept timed out retries = 54 Accept timed out retries = 53 Accept timed out retries = 52 Accept timed out retries ...
- Tue Jul 20, 2004 11:17 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Failed to connect to host ?
- Replies: 4
- Views: 2554
Help: HOW to get my DS server up and running
Ray, 1. A client was connected to DS server, when it was brought down. 2. After sometime the DS server was started. When client was trying to connect to the server it gave RPC daemon failed. 3. We killed a dsrpc process (fin_wait_2) thread 4. after which we tried to connect to the DS, it gave the er...
- Tue Jul 20, 2004 6:16 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Data through Aggregator - not passed immediately
- Replies: 3
- Views: 1679
Re: Data through Aggregator - not passed immediately
Hi
One good practice in DS Server job design is to sort the data and perform all the aggregation operations in ODBC Stage itself.
Thanks
Pramod
One good practice in DS Server job design is to sort the data and perform all the aggregation operations in ODBC Stage itself.
Thanks
Pramod