DSXchange

Suppose we have this hash file called HASH. This same file is called at two places in the job . This hash is created from target table TGT in which both the insert and update is being done Source table SRC gives out the following columns: Key1, key2, col1, col2,col3 We look up HASH twice . one for ...

I need to make changes to a shared container. The compile option in the designer is not enabled for me to make the change. How does one make changes to a shared container. Do we need to copy the code on a new server job and then modify it and make changes out there and save it as a shared container...

Use the hash file to look-up, and in the transformer check if the look-up failed or suceeded, by using ISNULL() and assign a zero or 1 based on the result.

maffan76 wrote:it says "cannot kill the process" access denied

Login in as DS ADMIN user and try.

Editing the original post to remove the problem description is singularly unhelpful. Can you please reinstate it so that anyone searching for this problem in future can be helped? I am sorry for editing original post. In fact I thought I was duplicating the posts on the similar issue, which I reali...

I guess the first thing to be done to use a merge stage is to remove duplicates, in your case the location and position are keys, and you have duplicate values. So you cannot use merge stage for this.

I am facing a problem with parameters That is when we pass parameters dynamically from batch job to sub batch jobs.Those callable jobs are every time aborting due to SQL connection failure because of I think those are getting some nulls or wrong passwords. thatswhy my host user Oracle source user I...

I had a similar issue couple of times, the reason was there were some locks on the target table. once you are able to unlock them , then I guess you can get rid of the issue.

Thanks, chulett. Appreciate your help.

chulett wrote:Sounds like the dreaded Windows XP Service Pack 2 related problem. There is a patch available on Ascential's eSupport website, download and install it and it should fix you right up.

Posting the original issue When using the sequence to run the jobs in the windows environment, datastage 7.5, it was working fine. But when we were doing the same in unix environment, the jobs were failing with the "logon denied" error message where ever the database stages are used. In fa...

This option is enabled in server jobs, but not in PX.
Also you can do a work around as Roy said, but this would only put a limit on the input rows and not on output rows. For Ex your job may be limited to read only 1000 rows and process them, but your output may still have just 10 rows, or 2000 rows.

Saravanan's method could work, if you take the inrow-num and apply mod function with 3 as divisor and if get zero as a result then it goes to the third file, else apply mod with 2 as divisor and if get zero then it goes to second file, else it goes to first file. By this we could know which is first...