DSXchange

Ray - I have my sampling specfication with the highest value possible, '9999'. chulett - You have precisely stated our scenario. When we repeatedly view the exact same static data over and over using the same settings, the results are not identical. We shall get in touch with our vendor support as y...

The datatype is Interger.
I'm not getting any error /warning message when I view data. But, it just misses some records...

No, they are not skipped. So far when we have run the job, I see them in the output. The problem is only when I view the data from the stage. Because it sometimes shows up and sometimes does not with view data, we are worried that, if that would drop those records during some runs.

I'm doing nothing differently.

I just repeatedly do a view data, and at times is shows all records and at certain times does not show the last few records with -1.

Hi, We have a Sequential File stage as source that reads a .csv file. This file has 115 records in it. The last few records have a value of -1 in one of the columns. When we do a view data on this stage, the number of records that show on the screen are inconsistent. Sometimes it shows all records i...

Thanks for all your response. Our requirement was to make both of these happen. 1) Abort the job immediately if an invalid value comes through. 2) Capture just the one record (first record) value that passed through the abort condition. We were able to achieve this at the end. Initially the output e...

Hi, We have a job where we want to abort the job when we get some invalid values for a column. We handle this using the "Abort After Rows" option in the Transformer. The output of that link is sent to a Sequential File stage to capture the invalid value. The limit is set as '1'. When we ru...

lstsaur, no, the job log did not show entries from the link where reference data is fetched. Infact we are using a join stage for fetching the reference data and not a lookup stage.

ray, we did not try using Entire partition. Will check that and see what happens...

lstsaur, I checked the log and it does not show this information. The reference table has 5 records and I see the same count that shows on the link using performance statistics. I'm sure the records are not being dropped. ray, the partitioning algorithm on the reference link is Hash partition on the...

Hi, We are working in a DataStage Grid environment with multiple compute nodes. We came across a situation that worked unexpectedly. We run a job using 2 compute nodes and 2 partitions each. The job works as expected. The lookup to an Oracle table fetches correct reference data. When we run the same...

Hi, We have a requirement to pass a windows shared folder link in the email body of the Notification Activity. This shared folder link has spaces inbetween in the folder names. When we give this as folder link name in the email body, the complete folder link does not come as hyperlink in the email s...

Hi, In the Email Notification stage, we are trying to provide an output filename in the email body. This file is created by a previous job. So, we have to dynamically obtain the name of that file and put it in the email body. We tried to get the filename using a routine and then provide it in the em...

Thanks a lot Craig.

I did it the way you said in After-job ExecSH. It worked.

Thank you...

Thanks Craig.

I changed it to 'back tick' and ran and still its not working. I tried creating the file using this through command line and that worked. But when I give this expression within the stage in DS, it does not work. Any idea...

If your concern with the Unix option is that you don't want another 'asset' to have to manage outside the DataStage environment then couldn't you just supply the 'script' in the filename specification? E.g. Something like ... MyFilename_`date +%Y%m%d-%H%M%S`.txt I've been working in a purely PX env...