DSXchange

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.

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...

Thanks Craig,

I will go through these document and check out configuration for my specific requirement.

regards,
Sachin.

Hi,

so how are we identifying Conductor and Section leaders and players created.

question is if number of processes created by OS should be less or more for performance tuning.

thanks,
Sachin.

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...

There is ctrl M character in file, which i can remove using unix script, but wanted to remove using stage if any available.

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.

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.

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.

Thanks Ray.

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.

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.

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.

In my env all job parameters defined in parameter file overrides the value of parameter set in job design.

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...