Hi Team,
I have two files as input on Unix file system which has to be joined, should i go for Unix join operator or should i use Data stage join which will have these file as input.
Please assist.
Thanks,
Sachin.
Search found 324 matches
- Sun Mar 11, 2018 6:04 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: which one is best Unix Join or Datastage Join
- Replies: 2
- Views: 2506
- Wed May 10, 2017 1:09 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Configuration file
- Replies: 9
- Views: 7245
Reading through one of the document I found that. for any jobs that is executed with all parallel executing stages, their would be list of process. (1 Conductor process) + (number of processing nodes= Section leaders) + (number of parallel running stages * section leaders). so for example for 3 stag...
- Tue May 09, 2017 12:09 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Configuration file
- Replies: 9
- Views: 7245
- Mon May 08, 2017 3:43 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Configuration file
- Replies: 9
- Views: 7245
- Sat May 06, 2017 5:33 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Configuration file
- Replies: 9
- Views: 7245
Configuration file
Hi Team, I have 8 CPU on SMP, I am trying to understand if I configure 2 logical processing nodes with 4 CPU's each would be best or should I configure 4 logical processing node with each having 2 CPU's. Wanted to check on understanding that if number of processing node is increased the processes wi...
- Wed Oct 31, 2012 12:03 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Remove unwanted character from file using any stage
- Replies: 6
- Views: 4902
- Thu Oct 25, 2012 4:05 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Remove unwanted character from file using any stage
- Replies: 6
- Views: 4902
Remove unwanted character from file using any stage
Hi,
Please let me know if we have any stage in Datastage 8.1 to remove unwanted character from file and move data further for processing.
regards,
Sachin.
Please let me know if we have any stage in Datastage 8.1 to remove unwanted character from file and move data further for processing.
regards,
Sachin.
- Tue Mar 30, 2010 1:02 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Ideal Configuration
- Replies: 2
- Views: 2035
Ideal Configuration
Hi all,
We will have near about 100 client user connected to Server System(DataStage Server 7.5.1a).
My concern is regarding what should be ideal configuration for system installing Datastage server.
1. Ram size ?
2. Should we go for SMP or MPP.
thanks,
Sachin.
We will have near about 100 client user connected to Server System(DataStage Server 7.5.1a).
My concern is regarding what should be ideal configuration for system installing Datastage server.
1. Ram size ?
2. Should we go for SMP or MPP.
thanks,
Sachin.
- Thu Feb 11, 2010 4:59 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Automate Converting OCI 8 to OCI 9
- Replies: 3
- Views: 3429
Re: Automate Converting OCI 8 to OCI 9
Hi Suresh,
i just have information regarding an utility OCI8TO9.B, which converts your oracle oci8 stage to oracle 9i OCI stage, but never tried it.
please check out on more details on OCI8TO9.B utility.
i just have information regarding an utility OCI8TO9.B, which converts your oracle oci8 stage to oracle 9i OCI stage, but never tried it.
please check out on more details on OCI8TO9.B utility.
- Wed Nov 04, 2009 1:24 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Usage Analysis
- Replies: 3
- Views: 2515
- Wed Nov 04, 2009 12:41 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Usage Analysis
- Replies: 3
- Views: 2515
Usage Analysis
Hi All,
when i do Usage Analysis for a particular job in Data Stage Manager, i get nothing in output, i mean their is no information displayed.
Thanks,
Sachin.
when i do Usage Analysis for a particular job in Data Stage Manager, i get nothing in output, i mean their is no information displayed.
Thanks,
Sachin.
- Tue Oct 27, 2009 11:02 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Using DataStage job to execute Oracle Stored Procedure
- Replies: 4
- Views: 4642
Re: Using DataStage job to execute Oracle Stored Procedure
i think working with stored procedure stage is not so hard, if you could please read an help on stored procedure stage will help you, put on your query if you face any.
- Tue Oct 27, 2009 12:23 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Oracle OCI Stagge
- Replies: 4
- Views: 3685
Re: Oracle OCI Stagge
Yes i am also getting the same error, but the single statement executes fine, so what should be the seperator between two statement to work fine in before sql of oracle OCI.
- Tue Oct 06, 2009 9:49 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Parameters
- Replies: 7
- Views: 3856
- Thu Sep 10, 2009 6:33 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Pass values from file to WHERE clause in query
- Replies: 7
- Views: 4200
Re: Pass values from file to WHERE clause in query
your operating system is unix as you mentioned so it will be great that you create one more file which will have just one single record from your file which is having 20 values and use this file having single record for your lookup condition. you can create a single record from file havig 20 records...