DSXchange

Hello Guru's, Good morning. I have a tricky situation and please let me know your suggestions. Issue: Creating/Inserting a record in a hashed file from one server to another server. Datastage is sitting on a UNIX AIX box. I'm using and updating surrogate key in a hashed file in a QA server and I hav...

I put a workaround by calling Unix command to call the job in loop.

Hello Everyone, Good afternoon, Goal: Invoking a child server job n no of times at the same time in parallel. Scenario: 8 files should be processed into the same staging table. Using the sequencers the job can be invoked using diff parameters ( say load1.... load 8 ) at the same time, but 8 diff seq...

For me, the ds job report utility is the coolest one. You can just click and get the full details about the job which is amazing :D and it reduce lot of work on the documentation side of it.As a developer I've loved it. I am on datastage 8.0.1.

Thanks,
Saran

Hi Everyone, I am sorry to reopen this topic after almost 4 years. Today I have faced the similar issue and this is what am trying to do now. a. I have logged into information sever manage console b. When I try to import the whole project ISX back up it automatically lists all the objects (jobs, con...

Hi Synsog,
Inner join will work the same way it works in Datastage. Can you please check the constraints in the informatica stage, which you have used. It should retrieve all the matched three rows. There are no difference between inner join in Datastage and Informatica.

Hi, I am running datastage server jobs through peoplesoft packages. I used a set of batch job which inturn trigger the datastage job,which neeeds to run. But im getting the job status as running eventhough the job has been completed successfully. As this causes issues in prod can one help me out fr...

I'm still not certain what the original question means. Is it, perhaps, an interview question that you have faced? ... Hi ray, In my project we are running the Datastage jobs through peoplesoft environment. I have a set of jobs in Datastage that inturn triggers someother datastage jobs. As for as u...

What is the difference between the server , parallel and mainframe jobs?

Explain me about wrapper jobs which is used to kick of the child datastage jobs?

how to avoid phantom jobs?