DSXchange

Thanks Rom! Will keep that in mind

Hi, Can anyone tell me some details about combinable/composite operators. The manual does not talk much about these. Also i wanted to know that what is the exact procedure that the OS/osh follows to combine operators in the same process. Can someone suggest the logic/implementation logic for the sam...

Hi All, I need to know the procedure to install DataStage PX on a Linux Machine. Firstly can this be done or would it only work with licensed UNIX versions. If i can install on linux can somebody tell me the following: 1) Can i setup a self loop on the machine and have the server run on Linux and cl...

Hi, The Phantom error comes mostly due to a data type mismatch. You would need to analyze your meta data mappings to see if all the columns i.e. source and target are in sync with each other with respect to the meta data. It could happen that the error has creeped in one of the transformers that you...

Hi Sumit, I was also getting this problem. This is a problem with the Server machine. The Datastage server would need to be restarted (Not the services). You may have to raise a ticket with your sysadmin was a hard restart of the machine. This solution solved my problem and i guess would be helpful ...

Hey ,

thanks a lot. I will try out this routine tomorrow. I guess this should solve my problem.

Mayank :D

Hi,

I need to compute the difference between 2 timestamps and store the results in "seconds" in the target table. This field is a duration field and so the timestamp be for the same day. How do i implement this. Can this be done using iconv and oconv functions?

Thanks,
Mayank

Hi All, I want to do a join on a table with a hash file. I have to join using 3 fields from the hash. While joining I shud be able to check whether the column I am joining with, has any data or not. If there is no data in that column then I have to join it with a default value. I am facing difficul...