DSXchange

Hi, Thankyou Chand. But you did not clear my doubt clearly. Should we maintaint same setting in both the server, is so you told that it can be dont throught the configure option. Also how many files are there in Parallel extender that we have to configure. Regards, Rajeev Prabhu HI Rajeev, You can c...

Hi, We have installed the Datastage server 7.1r1 in our PC, now we want to find through which port we can connect the Cleint to Server, can any one help us immediatley. Can we connect the Client and the server through the Server IP, or is there any port that has to be identified, if so how do we fin...

Hi,

I am using Datastage 7.x and i am using Oracle Enterprise stage to insert the data into table, it populates millions of records daily, i want to do commit on certain intervals or on completion of 100 or 1000 rows how can it be done or what is the option to do the same.

Regards,
Rajeev Prabhu

Hi,

What is the datatype of the column "Exchrate" that you have specified in the source and the Rejection.

Regards,
Rajeev Prabhu

Hi Vignesh, If the reference to a Lookup is directly from a table, and the number of input rows is significantly more than (eg. 1:100 or more), and if job is small enough to fit into available physical memory, then go for lookup. Else go for join or Merge Stage. in what scenario we used join, lookup...

Hi, For Datastage 7.x where is the configuration files stored and how many configuration fles are there. We have a Development DS Server in which we have developed our jobs, since we have to put this to production we have installed the DS server in different machine. Is it necessary to set the same ...

Hi, Ray Thanks you. But when i was going through the DS documents that we get during instation, i came to see that log files are stored in hash files. Is there anyway to reduce the size of the log files?. Regards, Rajeev Prabhu DataStage job logs are located on the server. However they are not log f...

Hi, I am working in DS 7.X and using Parallel extender properties, i am new to DS 7.x. I developed 4 jobs and i had run 4 jobs y'day evening and went home. Each job loads about 1 million rows. When I came to see the same this morning, only 400,000 rows were loaded and the 4 jobs aborted. I tried to ...

Hi,

Thank you Ray.

Regards,
Rajeev Prabhu

ray.wurlod wrote:If you run the job from a job sequence, you can choose the run mode to be "reset if required, then run".
Then you schedule the job sequence.

Hi, Thank you Vinod. As per your advice we will have to execute the script manually. Is there any other way by which we can do it automatically in Job Seqencing or Scheduling. Regards, Rajeev Prabhu If you are running a unix script to run your job, you can reset the job by the following command: ${D...

Hi, I am having a senario as follows, i am having set of jobs and all are independent, i schedule them to run during nights. We have two databases, that we have to connect and then do the population to the staging area, which is done by these jobs. It is one to one mapping from Source to Staging. Du...

Hi, Thank you Ray and Legendkiller, for the reply. I would like to add to the above discussion, what are the stardards for new stages maintained in 7.x. Like join, change capture, Funnel etc. Regards, Rajeev As a general rule, standards are developed in-house. The important thing is that they are co...

Hi,

I want to know the standards that are used in Dastastage when you design a job in Designer.

Regards,
Rajeev