Search found 24 matches
- Tue Sep 20, 2011 10:54 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Need help in generating logic with good performance
- Replies: 1
- Views: 1209
Need help in generating logic with good performance
Hello Everyone, I have below requirement in one of my job, can someone please let me know the efficient way to work on this. Column1 Column2 123 First 123 Test1 123 Test2 123 Test3 Column1 Column2 Column3 123 First Test3 If only one record with key value then Column3 is null I thought of using 2 rem...
- Fri Jun 08, 2007 11:49 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: one to many relationship in joins
- Replies: 8
- Views: 3148
- Tue Feb 13, 2007 4:33 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Filter commad error in datastage seq files
- Replies: 3
- Views: 2509
Filter commad error in datastage seq files
Hi All, In datastage job I reading a file using the SEQ file stage. file has Header and Footer in it along with column names. 1st record is Header 2nd record is column names last record is Trailer record I'm using sed command in the filter comand of the sequential file. Previously we use to read the...
- Fri Jan 26, 2007 2:01 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: oracle lookup failure
- Replies: 7
- Views: 2638
- Fri Jan 26, 2007 12:35 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: oracle lookup failure
- Replies: 7
- Views: 2638
oracle lookup failure
Hi, In one of my jobs Source, lookup and target are Oracle Enterprise stages. Job is getting filed for the lookup stages (Oracle Enterprise stage) because of below error. I able to connect with same user_id and passwd from database tools. Is there any do I need to cofigure for doing lookup. Please l...
- Thu Feb 02, 2006 1:37 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Discrepancy in records
- Replies: 2
- Views: 1649
Discrepancy in records
Hi All, I have created a job which is loading into a file. I am getting the required output but in couple of records from column 3 it is moving one column a head. ie 3rd column is becoming null and 4 col will have 3rd column value, 5 will have 4th value and soon. Column 1 and 2 are hardcode values. ...
- Mon Jun 13, 2005 3:27 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Director error
- Replies: 4
- Views: 2163
- Sat Jun 11, 2005 8:42 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Director error
- Replies: 4
- Views: 2163
Director error
Hi All,
I am getting following error when i try to connect to Datastage Director.
(The connection was refused or the RPC daemon is not running (81016)
Can explain me how to resolve it
Thanks
Suri
I am getting following error when i try to connect to Datastage Director.
(The connection was refused or the RPC daemon is not running (81016)
Can explain me how to resolve it
Thanks
Suri
- Sat Jun 11, 2005 6:58 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How Dataset differ from Sequential File stage
- Replies: 5
- Views: 2814
How Dataset differ from Sequential File stage
Hi All,
Can any one explain me the difference between Sequential File stage and Dataset stage in parallel extender.
Thanks in Advance
Suri
Can any one explain me the difference between Sequential File stage and Dataset stage in parallel extender.
Thanks in Advance
Suri
- Mon Jun 06, 2005 5:51 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Can we Call Server routines in Parallel Extender
- Replies: 5
- Views: 2921
Can we Call Server routines in Parallel Extender
Hi All,
Can we call server routines in paralle. I know they use different languages and different compliers. I am wondering is there any way to use server routines in parallel.
Thanks in Advance
Suresh
Can we call server routines in paralle. I know they use different languages and different compliers. I am wondering is there any way to use server routines in parallel.
Thanks in Advance
Suresh
- Mon Feb 07, 2005 3:37 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Data Comparision
- Replies: 5
- Views: 2128
- Mon Feb 07, 2005 3:14 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Data Comparision
- Replies: 5
- Views: 2128
Data Comparision
Hi ,
Does anybody tell me to how to do compare the source and target data and reject the records into a file which does not fond a match and also the count of the number or records matched and the count of the records that are not matched.
Thanks
Does anybody tell me to how to do compare the source and target data and reject the records into a file which does not fond a match and also the count of the number or records matched and the count of the records that are not matched.
Thanks
- Wed Sep 29, 2004 4:41 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: move sybase timestamp data to db2
- Replies: 1
- Views: 1373
move sybase timestamp data to db2
Hi,
I want to move(stright move) Sybase data to Db2. Do i need to write SQL at Sybase stage (since sybase support 23 lenth of timestamp where as DB2 26) or shall i move directly, is datastage take care of padding with 0.
Thanks
Suri
I want to move(stright move) Sybase data to Db2. Do i need to write SQL at Sybase stage (since sybase support 23 lenth of timestamp where as DB2 26) or shall i move directly, is datastage take care of padding with 0.
Thanks
Suri
- Tue Aug 03, 2004 12:36 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Convert Row's to Columns and Columns to Rows
- Replies: 3
- Views: 2175
Convert Row's to Columns and Columns to Rows
Hi,
I am new to this tool and I need some help.I want convert the Rows to Columns and Columns to Rows, I need to write Routine or is there any other way in Datastage.
Thanks
Suresh
I am new to this tool and I need some help.I want convert the Rows to Columns and Columns to Rows, I need to write Routine or is there any other way in Datastage.
Thanks
Suresh
- Mon Aug 02, 2004 8:36 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Difference between lookup stage and hash stage
- Replies: 1
- Views: 1294
Difference between lookup stage and hash stage
Hi
I woud like to know what is the difference between lookup stage in mainframe and Hash stage in server.
Thanks
Suresh
I woud like to know what is the difference between lookup stage in mainframe and Hash stage in server.
Thanks
Suresh