DSXchange

Hi,

Both the datatypes are same ie; Integer (11).

Thanks,

Hi Ray, I/P File1-->TRANSFORMER--->AGGREGATOR--->COPY --->O/P1 > JOIN --->O/Pfinal I/P File2-->TRANSFORMER--->AGGREGATOR--->COPY --->O/P2 In the above structure, I am verifying the o/p of two COPY stages which are being joined. Both the OP1 and OP2 are giving the same value(872759) as I mentioned as...

Hi Kiran, Thanks for your response on my problem. Please see the problem details below. 1) I am getting the record count using aggregator stage from 2 types of input. 2) 1st input(sequectial file) using aggregator is giving the record count 872759 3) 2nd input(sequectial file) using aggregator is gi...

Hi all, We are using a JOIN stage with the inner join on a double column. Both the inputs that are coming to the JOIN stage are having hte one matched value but the output I am getting is nothing. But when I just replaced the JOIN stage with the LOOKUP stage it is working fine without any other chan...

Hi,

I think the problem is not with SetNull() but is with IsNull() function. Sometimes it does not recognize the null value in the input string. Instead SETNULL() try with the following
Len(Trim(LNK_XFRM_REAL_EST_STORES_DM.store_open_dt))=0

Hope it will work for you.

Thanks.

Hi all, I am facing a problem in converting a julian day to DATE. Ex: The Julian day value I am getting from source is like 12350 (20011023). When I am using the following DatefromJulianday function in he transformer then I am getting the error like "Error n converting" But when I try usin...

Hi Gurus, I have created a small Oracle stored procedure which returns an integer. Now, I would like to use the stored procedure into datastage job. For that I am trying to import the Stored Procedure definition after doing the following steps. 1) Updated uvodbc.config file on UNIX server with the f...

I created a routine using the c++ function. My C++ function takes 2 raguments and returns float value. float IsNumberInRange(int len, float val); when i am trying to use this routine, the job is getting aborted, as there is no float data type in the date stage, i tried to run the job by giving diffe...

In the director Log we are finding the following decsiption:
Error setting up internal communications (fifo RT_SCTEMP/job_INSERT_FILE_STATUS.fifo
LOCKED STATUS () -1); file is locked
what should be done when we get this error, and please update the actual reason for the error.

Hi Gurus,
When I am running a job from the Unix prompt, it is being initiated. Then OSH Script is intiated. From there it is not moving further. It is being strucked.
How can we track the status and why it is being strucked like that?

Thanks.

My sequencer is like There is one job from which I am taking one one input file and the output would be some 100 files depending on some criteria. So in my Sequencer this would be the first job. Then for each file there is a one specific job. That is for 100 output files from the above job I have cr...

Ajay, Actually, I am writing source file data to one temporary file. Now I want to check whether the temp file exists. If it exists then only I wud like to run the corresponding jobs. Otherwise I dont want to make any call to the corresponding job. Now, please let me know if there is any possibility...

Hi Ram, Thanks for reply. It is a very good Idea actually. But in our case, the sequencer is very huge. We are having 100's of jobs being called in the sequencer. Hence 100's of Exceute Command activities should be called before 100's of jobs. So, it would be a big change. So I am looking for any op...

Is there any effective way to check that?

Hi,
I have a sequencer which runs 100s of jobs in parallel. All these jobs are being ran even though if the input file is of 0KB. which is actually wastage of time. So We want to restrict those jobs from being ran when there is no input file. Can anybody help me in finding a way out?

Thanks.